Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default How do I use tabs in a macro?

A macro doesn't have to look at the activecell,. you can direct it ant any
cell that you want to.

What precisely do you want to do, as we may be able to help beater with this
knowledge.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Gale" wrote in message
...
When writing a macro, it seems that excel looks at the exact cell you are

in.
I want the macro to perform the function of going to the right after the

tab
key is pressed, no matter what cell I start in. Anybody know how to do

that?


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
Macro recorded... tabs & file names changed, macro hangs Steve Excel Worksheet Functions 3 October 30th 09 11:41 AM
Renaming Tabs in a Macro Liz C Excel Discussion (Misc queries) 3 October 30th 08 04:29 PM
Macro to name sheet tabs Bill_S Excel Discussion (Misc queries) 4 April 10th 08 03:45 PM
How do I use tabs in a macro? mangesh_yadav[_47_] Excel Programming 0 August 27th 04 04:55 PM
How do I use tabs in a macro? Frank Kabel Excel Programming 0 August 27th 04 04:54 PM


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