#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default jump

Hi, Can anyone help with this:

How can I jump to the first cell in the same row in a macro?

Thanks in advance
jobra
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default jump

Hi Jobra.

ActiveCell.EntireRow.Cells(1).Select



---
Regards,
Norman



"jobra" wrote in message
...
Hi, Can anyone help with this:

How can I jump to the first cell in the same row in a macro?

Thanks in advance
jobra



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default jump

Thank you very much Norman, I appriciate your help.

"jobra" wrote:

Hi, Can anyone help with this:

How can I jump to the first cell in the same row in a macro?

Thanks in advance
jobra

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default jump

alternatively

Cells(Activecell.Row,"A").Select

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Jones" wrote in message
...
Hi Jobra.

ActiveCell.EntireRow.Cells(1).Select



---
Regards,
Norman



"jobra" wrote in message
...
Hi, Can anyone help with this:

How can I jump to the first cell in the same row in a macro?

Thanks in advance
jobra





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
Key to Jump to end of row Susan Excel Discussion (Misc queries) 2 August 4th 09 10:19 PM
Worksheet Jump TGalin Excel Worksheet Functions 1 March 10th 09 05:55 AM
Jump to cell ickleyates Excel Discussion (Misc queries) 2 October 18th 08 04:58 AM
Before I jump off my desk... drumbumuk Excel Discussion (Misc queries) 4 October 9th 08 07:16 PM
HOW TO JUMP TO THE LAST CELL IN A ROW? Mark Excel Discussion (Misc queries) 3 October 10th 05 03:40 PM


All times are GMT +1. The time now is 06:47 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"