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/308212-re-how-do-i-use-tabs-macro.html)

Frank Kabel

How do I use tabs in a macro?
 
Hi
activecell.offset(0,1).select

--
Regards
Frank Kabel
Frankfurt, Germany


Gale wrote:
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 02:12 AM.

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