poorwallace
Active Member
- Joined
- Mar 8, 2005
- Messages
- 365
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
Any suggestions?
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
Code:
Dim LstC As Long
LstC = Cells(Rows.Count, 4).End(xlUp).Rows
Cells(LstC, 4).Offset(0, 1).Value = 1
Any suggestions?