Menu

Changing formulas from relative to absolute

Search this Thread

Prev

Previous Post

Next Post

Next

#5

Report Post

Posted to microsoft.public.excel.misc

Don Guillett

Posts: n/a

Default

Changing formulas from relative to absolute

glad to help

--
Don Guillett
SalesAid Software

"Axel" wrote in message
...
Thanks a lot Don and Pete! This helped.

"Don Guillett" wrote:

Have a look in vba help index for CONVERTFORMULA

--
Don Guillett
SalesAid Software

"Axel" wrote in message
...
I have many already existing formulas in a sheet, now I'm looking for an
easy
way to change all these formulas from relative to absolute.

Reply With Quote

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
how to switch between relative and absolute references	KeKe	New Users to Excel	2	June 9th 06 05:23 PM
Changing relative to absolute for a column	John K	Excel Worksheet Functions	6	May 17th 06 02:51 AM
Automatic absolute formulas	Greenback	Excel Discussion (Misc queries)	2	February 2nd 06 05:37 PM
How to convert relative to absolute addressing instantly in Excel	loudun	Excel Discussion (Misc queries)	3	November 24th 05 05:37 PM
Relative goes absolute between worksheets in data sort!	Kevryl	Excel Discussion (Misc queries)	6	January 20th 05 05:01 AM

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

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement