Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 271
Default VBA to select cell in column A

I need a simple VBA that will move the active cell to the A column in the
same row.
--
Thanks
Shawn
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,501
Default VBA to select cell in column A

Try this

Cells(ActiveCell.Row, 1).Select

Note it's unlikely you have to select the cell to do what you want.

Mike

"Shawn" wrote:

I need a simple VBA that will move the active cell to the A column in the
same row.
--
Thanks
Shawn

Reply
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
VBA: Column Select then Data Select then return to cell A1 James C[_2_] Excel Discussion (Misc queries) 3 February 1st 10 11:35 AM
select every other cell in a column deb Excel Discussion (Misc queries) 3 June 23rd 08 02:35 AM
how to select a single column when this column cross a merged cell cnEagle Excel Programming 1 November 13th 07 04:49 AM
Select cell where column and row intersect. [email protected] Excel Programming 6 December 3rd 06 08:01 PM
How do I select last cell in column plus 1? limshady411 Excel Programming 3 November 11th 05 02:56 AM


All times are GMT +1. The time now is 06:10 AM.

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

About Us

"It's about Microsoft Excel"