Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need some help! I would like to have everysheet in the workbook put
the cursor in cell A1. I have already written some code and this will keep every worksheet nice and neat when someone selects a particular worksheet. Below is what I have so far. The problem is the cursor goes in the cell A1 but the sheet isn't scrolled up. For instance, if the cursor is in cell C100, the code puts the cursor in cell A1, but the worksheet stays where cell C100 is visible and doesn't scroll up to so cell A1 is visible. Any help is much appreciated. Thanks in advance. Dim WkSheet As Worksheet For Each WkSheet In ActiveWorkbook.Worksheets WkSheet.Activate ActiveSheet.Range("A1").Activate Next Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Putting a hyperlink into a protected worksheet | Excel Discussion (Misc queries) | |||
putting one name under another on a cell | Excel Discussion (Misc queries) | |||
Putting a word into a cell. | New Users to Excel | |||
SAP BW Report - Putting the Unit of Measure or Currency in another Cell based on Format Cell | Excel Programming | |||
Putting items from list box multi-select onto worksheet | Excel Programming |