Inserting formula in array of cells using VBA

[shinobi]

Hi - I’m trying to write some VBA code that puts a formula in a range of cells (a grid of, maybe, 50 cells - which will vary in size, so I first defined the range in my code and gave it a name (say, TargetRange).

I then tried to select that range by using

Range (“TargetRange”).Select

but the code keeps crashing here - doesn’t seem to like the use of the TargetRange variable.

Am I doing that right - or any other ideas?

Thanks!

 

[smozgur]

Thanks for taking the time to provide this follow up - always good to learn something through the process!