how would interpret this macro

[masterinex]

I guess Sheets("A") is selecting sheet A ,but what does it mean if I combine it with .Cells(i, 3).Value É



B = Sheets("A").Cells(i, 3).Value

[teylyn]

Hi,

there's probably a variable called "i" that has a number value, so the code

B = Sheets("A").Cells(i, 3).Value

means: assign the variable "B" the value of the cell in row "i",column 3 (which is C1 if i=1) on the sheet with the name "A"

hth

[masterinex]

ok I got it !