Screen viewing
No, nothing this complicated. I think Tom has it almost solved for me.
Thanks much!
"Sharad Naik" wrote in message
...
What exactly you want to do?
Are you trying to show one after another column
selected, to the user?
Then you need to add code for timing.
Below example will select 1st column(Cell A1), and
then after every 1 second will go to B1,C1..Till J1 (10 columns)
ThisWorkbook.Worksheets("Sheet3").Select
ActiveSheet.Range("A1").Select
i = 1
myTime = Timer
Do Until i = 10
If Fix(Timer) = myTime Then
DoEvents
Else
ActiveCell.Next.Activate
i = i + 1
myTime = Timer
End If
Loop
End Sub
Sharad
"Grace" wrote in message
...
When my macro is done, I would like it to show certain columns of a
sheet. When I record the keystrokes to do this, it looks fine. But when
the macro runs automatically, it ends up a few columns over. Her is the
code I recorded. What variable could be messing me up ( I think I may
have clicked relative references when I recorded the macro)?
Sheets("Resource Hours").Select
Application.Goto Reference:="R1C1"
ActiveCell.Next.Activate
ActiveCell.Next.Activate
ActiveCell.Next.Activate
Thanks
Dean
|