Posted to microsoft.public.excel.programming

Dave L[_3_] Dave L[_3_] is offline

external usenet poster

Posts: 1

Selective formula pasting

Hi

I'm very much a novice at VBA and have created a macro which includes a
formula to calculate a sales parameter. However as the number of rows in the
range will change month on month I need to alter the cell range that the
formula is pasted into. Is this possible?

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
Selective formula	AleVe	Excel Discussion (Misc queries)	5	March 3rd 10 05:39 PM
Formula to sum selective data.	Anto111	Excel Discussion (Misc queries)	0	July 23rd 08 07:44 PM
Pasting a formula in many different workbooks	Playa	Excel Discussion (Misc queries)	3	July 18th 06 05:57 PM
Pasting on Filtered Data Sheets without pasting onto hidden cells	CCSMCA	Excel Discussion (Misc queries)	1	August 28th 05 01:22 PM
Pasting formula as text	ExcelMonkey[_190_]	Excel Programming	3	March 14th 05 11:48 PM

All times are GMT +1. The time now is 01:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us