Coding Drop down

I am very now to VBA coding and tried to find reason for below scinario, 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 there,

Both versions worked for me, so I'm not really sure what your problem is

When writing code it is always better to use fully-qualified references as shown below:

Please Login or Register  to view this content.

Prefixing Range/Rows/Cells with a dot in the code above means that the worksheet from which these objects are derived is always the worksheet referenced by "wks", and not whichever worksheet happens to be active when the line of code is executed.


Hope this helps,

Regards,

Greg M

Thank you every one

It sound to me like you're talking about VBA intellisense.
Although I'm not totally sure why some objects/methods etc give intellisense & some don't.