grabbing cell value from different worksheet - solved

[nodding dino]

Hey all,

This one sounds too easy but i can't seem to be able to find the required syntax!

I would like to grab the value of a cell in sheet1 whilst I am in sheet2 and hold the value in a variable. I have found this this:

myvar=Worksheets("sheet1").Rows(1)

but instead of the row, I just want a single cell (A1) can someone please put me out of my misery...!!!

Thanks!

 

[nodding dino]

Re: grabbing cell value from different worksheet

solved.