Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select First Row of Active Column
Hi,
It's always funny how the most basic problems are the hardest to figure out. I need a macro to go to the first row of a colum when a user selects a cell below. For example, if I have selected cell D9, or D12, or D1000, I need it to go to cell D1. Or, if I have selected cell E9, E12, or E1000 I need it to go to E1. Thanks for your help, Derrick |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select First Row of Active Column
Hi Derrick;
Function GoToTop cells(1,activecell.column).Select End Function " wrote: Hi, It's always funny how the most basic problems are the hardest to figure out. I need a macro to go to the first row of a colum when a user selects a cell below. For example, if I have selected cell D9, or D12, or D1000, I need it to go to cell D1. Or, if I have selected cell E9, E12, or E1000 I need it to go to E1. Thanks for your help, Derrick |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select First Row of Active Column
On Mar 14, 3:04*pm, DownThePaint
wrote: Hi Derrick; Function GoToTop * * *cells(1,activecell.column).Select End Function " wrote: Hi, It's always funny how the most basic problems are the hardest to figure out. I need a macro to go to the first row of a colum when a user selects a cell below. For example, if I have selected cell D9, or D12, or D1000, I need it to go to cell D1. Or, if I have selected cell E9, E12, or E1000 I need it to go to E1. Thanks for your help, Derrick- Hide quoted text - - Show quoted text - Thanks for your help - I knew it was something simple. Have a great weekend. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
Macro with input box to Select a column on active sheet | Excel Programming | |||
How to select last active row | Excel Programming | |||
how do I select cells in column A thru F in the active row? | Excel Programming | |||
Select column cells to the left/right of active selection - an example | Excel Programming |