Method 'Range' of object _Global error (Error 1004)

[uppidon111]

Please Login or Register  to view this content.

i am trying to call values using a for loop and is giving an error please help me.

thank in advance.

[Richard Buttrey]

Hi and welcome to the forum

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

you have dimmed set_cell_range as a range therefore Excel expects to see a range address not something else like a formula.

similar lines of code will also need adjusting.

And purely as feedback I find your variable names quite confusing. The very least I expect of variable names is that they are intuitive. I took me a little while to understand stuff like
Dim set_cell_range As Range.

Think about adopting a naming convention where the initial character indicates the type of variable. I tend to use stuff like

Dim rNames as Range, stManager as String, lRow as Long

[uppidon111]

Thank You for reply.

this is the original code which is working fine and i have only added an for loop to get value from a 2D array instead of columns. and i tried the code as suggested which giving is me error for Goal Seek

Please Login or Register  to view this content.