LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 199
Default Moving to Column A using a macro

I have written an Excel macro but, before it runs, need to ensure the active
cell is in Column A (of the appropriate row).

Can anyone please tell me how to do this at the start of the macro. I have
searched all over the place for the answer but cannot find it. I could use
the offset command but the number of cells to the left will vary each time.
I thought there might be a Home command or something similar?

Thanks,

V

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving macro from one PC to another ChuckW Excel Discussion (Misc queries) 1 May 8th 07 02:45 PM
moving macro SherryJ Excel Worksheet Functions 2 March 28th 07 02:50 AM
Moving right in a macro BJS Excel Discussion (Misc queries) 2 August 27th 05 01:54 AM
moving the formula "average" over one column in a macro drumstu Excel Worksheet Functions 1 August 23rd 05 08:01 PM
Moving down one row in a macro Cathy S. New Users to Excel 3 January 4th 05 09:02 PM


All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"