Dynamic Ranges

[ngann]

I am trying to use a ctrl + shift + down arrow dynamic range but am unsure how to embed it in my current macro that has something along the lines of

Selection.autofill Destination: =Range(“J2:J330”)

please help

 

[ngann]

This one couldn't run and it said the below line was the cause.

Range("U2:U" & UsdRws).FormulaR1C1 = "=RC15/RC12"

 

[Fluff]

Missed that one it should be UsdRws2

 

[ngann]

WOW!! I would have never figured that out! My only remaining issue is there is a summary pivot table at the end that calculates this. Is there a way to get the macro to auto adjust that as well? I know I may be pushing my luck haha you can see the code for it at the end. Thanks so much for your help.

 

[Fluff]

You have definitely pushed your luck too far, because I've never used pivots & therefore know nothing about them.

 

[ngann]

Thanks for all your help!

 

[Fluff]

Your welcome