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 ?