Posted to microsoft.public.excel.programming

Office_Novice Office_Novice is offline

external usenet poster

Posts: 245

Programmatically add worksheet function

I haven't tried this before now and i am having a little trouble.

This is what i have:
Worksheets("Sheet2").Range("C1").Value = "=SUM(C2:C5000)"

And it works ok, But i wont always know the range. I need something like:

Worksheets("Sheet2").Range("C1").Value = "=SUM(C2:C" & LastRow)"

But i tried that and the function didnt recognize my variable. Any help
would be great.

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
Programmatically add a Formula in a worksheet?	circuit_breaker	Excel Worksheet Functions	3	July 6th 09 02:53 PM
Programmatically selecting first worksheet	Barb Reinhardt	Excel Programming	1	July 14th 06 12:38 AM
Programmatically selecting first worksheet	Barb Reinhardt	Excel Programming	4	July 13th 06 11:42 PM
How to add an image to a worksheet programmatically	mjohnson	Excel Discussion (Misc queries)	2	March 16th 05 04:48 PM
Programmatically Add Worksheet Event	The Vision Thing	Excel Programming	1	September 2nd 04 02:14 AM

All times are GMT +1. The time now is 09:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us