Posted to microsoft.public.excel.programming

Titus

external usenet poster

Posts: 9

How to Revert to ActiveCell.Formula = format from ActiveCell.FormulaR1C1 = format

When you record a macro, a small widow pops up with the stop button on
it. the other button is the relative button, if you press it before
recording your macro it gives you the direct cell address not the R1C1
style.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
ActiveCell.FormulaR1C1	Rick	Excel Discussion (Misc queries)	3	March 28th 10 10:36 PM
ActiveCell.FormulaR1C1	PapaDos	Excel Programming	0	December 7th 06 07:06 AM
ActiveCell.FormulaR1C1	Tom Ogilvy	Excel Programming	0	December 6th 06 08:03 PM
activecell.formular1c1	monika	Excel Programming	0	April 29th 04 10:13 AM
ActiveCell.FormulaR1C1	Leif Rasmussen	Excel Programming	1	October 16th 03 09:46 AM

All times are GMT +1. The time now is 02:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us