Log In
Register
Home
New Member
May 25, 2018
Offline
I am very now to VBA coding and tried to find reason for below scenario, Could someone help me.
1 - KK = Range("A" & Rows.Count).End(xlUp).Row
2 - Lrow = Cells(Rows.Count, 1).End(xlUp).Row
I have used above code for finding last filled last row in Columns A.
in first case while writing code i got drop down selection after Range("A" & Rows.Count) and in second case drop down not available. I have given one example, Can someone say why its not available while starting with "cells".
Is there any std procedure for this availability ?
October 5, 2010
Offline
Hi,
Both of those lines give me the correct answer for the last row in my data. But I'm not sure what you are trying to do that is causing you a problem.
Can you please supply a sample workbook with data and code so I can understand the context.
Regards
Phil
1 Guest(s)
