Excel Macro to fill up from Relative cell to Absolute

[TXRH]

Hi Everyone,

I am trying to make a macro fill up from whatever cell I have selected in Column E to cell E3.

E3 will always be the same but the Active cell in Column E will not be the same.

Thanks for your help!

 

[Weaver]

is it formulas or values you're filling?

for values, ,maybe

range("E3",activecell).value=activecell.value

for formulas

range("E3",activecell).formula=activecell.formula

If you're looking for a series, it might be a little trickier.

 

[TXRH]

This worked perfect! Thanks for your help!