Thread: Screen viewing
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Grace[_4_] Grace[_4_] is offline
external usenet poster
 
Posts: 106
Default 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