MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Tab Stops


Posted by Jeremy on January 15, 2001 7:15 AM

Is there any way to set tab stops in excel. i.e. designating which cells the tab button will carry you to.

Thanks!


Posted by Mark W. on January 15, 2001 8:36 AM

Tabulation can be restricted the to cells in the
current selection. For example, if you define a
cell range named "range1" as:

=Sheet1!$A$4,Sheet1!$B$5,Sheet1!$B$6

After performing a Go To... (Ctrl+G) to this range you'll
only be able to tabulate within this range.

Posted by Jeremy on January 15, 2001 8:58 AM

One more thing....

Mark,
You sent me a formula for formatting a date as text. Well, in my VBA, I have code written that will paste my information from one sheet to another (populating a database). The date on the first sheet is formatted as follows:

=TEXT(TODAY(),"mm/dd/yy")

When I run my macro once, it pastes the date as a text (with an apostrophe in front of it). However, subsequent running of the macro pastes my date as a date. How do I prevent that? Cell formatting doesn't work.

Thanks!!

Posted by Mark W. on January 15, 2001 12:42 PM

Re: One more thing....

Jeremy, I'm afraid that I'm out of my league on
this issue. Perhaps you should repost this
question and see if you get a nible from someone
who's more VBA literate. I would recommend that
you include the segment of your code that causing
you problems.