Posted to microsoft.public.excel.programming

Mark Lucas Mark Lucas is offline

external usenet poster

Posts: 4

Writing Excel formulas in macros - Help!!

I am attempting to use a macro to write a formula in to a blank cell. When
the formula is written, the cell reference in the formula has apostrophes
around it so it won't function. I'm sure there is a syntax step I'm missing.
Can someone help??

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
writing excel macros	TMiGNa	Excel Programming	11	August 24th 06 05:44 PM
writing macros in excel sheet	Richard Buttrey	Excel Worksheet Functions	7	May 10th 06 01:04 AM
writing macros in excel	jaffar	Excel Programming	1	May 5th 06 02:06 PM
Writing Excel Macros in VB.NET/C#	[email protected]	Excel Programming	0	January 19th 06 04:02 AM
Writing Macros in Excel	Shannon	Excel Programming	6	August 13th 04 07:58 PM

All times are GMT +1. The time now is 04:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us