Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code to go to start of line
I need code to go to the first cell of the given row I am in, without knowing
how many columns over I am when I run the macro. In other words, a user is going to be told to place their cursor on a line, and then run a macro. The macro will rely on getting to the beginning of the line, then going over to the 33rd column. Alternative (and maybe even better) would be to be able to say that I want the activecell to be the 33rd column (column AH), on the line from which the macro was launched. Either or both of these would be greatly appreciated. Thx. -- Boris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
code to go to start of line
activesheet.cells(activecell.row,1).select '1st cell in row
activesheet.cells(activecell.row,33).select 'col 33 Tim "BorisS" wrote in message ... I need code to go to the first cell of the given row I am in, without knowing how many columns over I am when I run the macro. In other words, a user is going to be told to place their cursor on a line, and then run a macro. The macro will rely on getting to the beginning of the line, then going over to the 33rd column. Alternative (and maybe even better) would be to be able to say that I want the activecell to be the 33rd column (column AH), on the line from which the macro was launched. Either or both of these would be greatly appreciated. Thx. -- Boris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I start the line graph at 0 on the x axis instead of 1? | Charts and Charting in Excel | |||
Need macro to start at a new line | Excel Worksheet Functions | |||
How do you start a new line within a cell? | New Users to Excel | |||
How to start this Line List | Excel Programming | |||
Macro to Start on a New Line Each Time | Excel Programming |