ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I use tabs in a macro? (https://www.excelbanter.com/excel-programming/308221-re-how-do-i-use-tabs-macro.html)

Bob Phillips[_6_]

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?




All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com