Posted to microsoft.public.excel.programming

mathel

external usenet poster

Posts: 64

Formula in a macro

I am running a macro in a workbook that finds the first empty row in a range,
then I have the pointer move to the next column (L) and up one. I need to
put a formula in that cell "=sum(K1:K45)". When I run the macro I am getting
a result in the cell "#NAME?" and the formula shows as "=SUM('K1':'K45')"

Can anyone help on how to correctly input the formula in the macro.

Thanks
Linda

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
help with the macro or with the formula	Igneshwara reddy[_2_]	Excel Worksheet Functions	6	March 22nd 07 09:16 PM
Formula in macro causes macro to fail	KCK	Excel Programming	2	February 8th 07 08:47 PM
macro or formula	CMD	Excel Programming	2	October 4th 06 08:58 PM
Formula expected end of statement error, typing formula into cell as part of VBA macro	[email protected]	Excel Programming	1	July 20th 06 07:58 PM
Formula & Macro	nik_gujarathi[_7_]	Excel Programming	0	May 26th 06 09:05 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us