Copying Formula into a Dynamic Range

Big H

Guest

Posts: n/a

23rd Oct 2006

Hi There,

I have a dynamic range of data, I have code that when run, inserts a formula
into cells H2 & I2, would it be possible to copy these formula into colums H
and I within the dynamic range. If it helps column B will always have data
on it.

regards BigH

« Change formulas into values based on cell color | Number Grouping Formula or Macro »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with copying dynamic column selected based on remote cell value and dynamic formula fill	ers	Microsoft Excel Discussion	0	1st Mar 2006 01:05 AM
Help with copying dynamic column selected based on remote cell value and dynamic formula fill	ers	Microsoft Excel Programming	0	1st Mar 2006 01:05 AM
Help with copying dynamic column selected based on remote cell value and dynamic formula fill	ers	Microsoft Excel Charting	0	1st Mar 2006 01:05 AM
copying dynamic range based on cell outside of range	xcelelder	Microsoft Excel Programming	3	29th Sep 2005 05:08 PM
Copying Formula to a dynamic range.	inetuse	Microsoft Excel Misc	1	22nd Dec 2003 09:43 PM