Get cell value and use as vba variable

Hi,

I am trying to find a way where I can use a worksheet cell value in vba code. ie.. I have vba code

Please Login or Register  to view this content.

Sometimes these values will change and I would like to just change them in a cell in a worksheet and have the code updated from the cell values. is this possible please.

Regards
David

Hi Robert,

Thanks for your reply,

I seem to have the values I want now in the variables but copying those values in the worksheet don't seem to work well. ie.. if I use

Please Login or Register  to view this content.

this will copy 2 different sections ie.. copies from B4 to B572 without the middle rows B202 to B435. if is use the strMyRange it copies all from B4 to B572?

What excactly are you trying to achieve? Why do you need the values in a variable?

You can also store the range itself in a range variable.

Please Login or Register  to view this content.