Doing search in worksheet
Thu, 9 Oct 2008 18:27:01 -0700
I need to search all worksheets to see if any cell has a formula in it? Any
help is appreciated. ...
|
Selection.EntireRow - Filtered
Thu, 9 Oct 2008 16:22:11 -0700
Hi,
I am trying to copy (selected) filtered data from one sheet to another.
Previously I have used Selection.EntireRow which copies a selection of
filtered rows.
I now need to just copy from Column C to Column AO - Not the EntireRow -
With only the rows that i select.
I have been using this...
Set ...
|
Prevent Escape on Nonmodal Userform with Progressbar
Thu, 9 Oct 2008 15:57:08 -0700
Is there any way to use a progressbar control in a modal userform?
I need to block users from accessing Excel or interrupting code execution by
pressing Escape
while a progressbar is being displayed.
Pressing Escape while a nonmodal userform is active returns â??Code execution
has been interrupted.â? Pr ...
|
Macro to run when cell click
Thu, 9 Oct 2008 15:43:00 -0700
I'm trying to write a macro to call a userform when you click in a cell. This
is what i've got which works when someone types a character in the cell.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$5" Then
userform1.show
End If
End Sub
Any way to change this s ...
|
Re: Finding a used / filled rows
Thu, 09 Oct 2008 14:50:43 -0700
Thank you Gord. It works.
However, I'm sorry I should of indicated at the and of my request; Once
it has found the used / filled row, it will select that cell.
Ogopogo5
*** Sent via Developersdex http://www.developersdex.com *** ...
|
false VBA cues
Thu, 9 Oct 2008 15:27:22 -0600
I entered a line of code that seemed to me it should work, since the cue
that appears when you enter a range using "Cells" says that "Cell2" is
optional (in brackets), but it's not.
This should be, if the cue were correct, an acceptable line of code:
Set rClient = wsTribalHist.Range(Cells(3, lHistDataFinal ...
|
sheets(N*).printout problem
Thu, 9 Oct 2008 14:07:02 -0700
why do I get erro #9 @ printing?
i have a other sub that runs the same line in the local woorkbook and ptints
just fine.
I thank in advance
Sub Imprimidor()
' On Error GoTo Fim
Dim x As Long
Dim Y As Long
Dim Formul As String
Dim Seq As Long
Dim Adit As String
Dim Clie ...
|
|
|
trouble with onchange event
Thu, 9 Oct 2008 13:50:24 -0700 (PDT)
I'm not sure where to go with this question so I thought I'd try this
group.
I'm having some trouble with the following VBA code. The varTags
variable is sometimes empty, and sometimes it has what it's supposed
to have. I always use the same set of pages to test.
I thought maybe the page needed time to lo ...
|
On save excel jumps to another worksheet. How to fix VBA code?
Thu, 9 Oct 2008 13:47:02 -0700
I have a multi sheet excel workbook that has VBA coding. When I go to save
the workbook it jumps to Page 7(Sheet7) and starts running the activate code
for page 7. How can I stop it from jumping to page7 on save. ...
|
Log specific changes
Thu, 9 Oct 2008 13:13:05 -0700
I have code in a workbook_BeforeSave event that Appends a txt file with an
entry that stamps user & date/time when the file is saved. I would like to
log any specific cells that are changed. The workbook has many worksheets and
I can conditionally choose the time period that I want to track the changes.
If c ...
|
