Getting an Excel cell value into a String in VBA

[VBAguy22]

Hi,
I am looping through my column and trying to read in the value. I am using:
name = Range("A" & i).Value
where i is a number between 1 and maxRows and 'name' is a string.

for some reason name always comes out empty ( "" )
Am I not reading it properly?

 

[DaveInIowa]

You're looping through the rows of the active worksheet. Try qualifying the Range with a worksheet object.

name = ThisWorkbook.Worksheets("nameofworksheet").Cells(i, "A").Value

 

[DaleWatson123321]

Hi VBAguy22,

I'd suggest the problem is simply that "Name" is a reserved word. I'm confident you'll eliminate the problem by using another (non-reserved) name as a variable. ;-)

I hope this helps.

Regards, Dale Watson