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 ?
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
