Rows.Count Problem

[poorwallace]

Question....

I'm having a particular problem on what should be a routine issue. When I try to determine the last cell in a range, VB is recognizing the cell value... This seems strange to me, as I've used this before with no problem.

the problem is that the last cell in the range is populated with a 4. VB is taking that 4 and using it as LstC. Thus, instead of the 1 being input next to the last cell in the column, it is being input next to Cells(4, 4).

Here is the code

Dim LstC As Long
LstC = Cells(Rows.Count, 4).End(xlUp).Rows

Cells(LstC, 4).Offset(0, 1).Value = 1

Any suggestions?

 

[Scott Huish]

Change Rows to Row

LstC = Cells(Rows.Count, 4).End(xlUp).Row

 

[Tazguy37]

This one:

LstC = Cells(Rows.Count, 4).End(xlUp).Row

HTH

 

[poorwallace]

Guys, that was it! It always seems to be something simple. It's amazing I can still do stuff with gaps like that in my basic knowledge

Oh well. Thanks a bunch!