Drop down option not available while coding

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

  • No.


    Range is an object that is documented to work with Intellisense. Cells() is not. Ergo why many choose Range over cells. I do like cells sometime where you can also use "A" where you used 1. That can be handy sometimes...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!