View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] derrick.perkins@gmail.com is offline
external usenet poster
 
Posts: 8
Default 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.