T T2B Apr 28, 2012 #1 In VBA for a named range, I need to return: row count, last occupied cell column count, last occupied cell Thanks.
In VBA for a named range, I need to return: row count, last occupied cell column count, last occupied cell Thanks.
I isabelle Apr 28, 2012 #2 hi, rw = Evaluate("MAX(IF(" & [rng].Address & "<>"""",row(" & [rng].Address & ")))") cmn = Evaluate("MAX(IF(" & [rng].Address & "<>"""",column(" & [rng].Address & ")))") -- isabelle Le 2012-04-28 08:21, T2B a écrit :
hi, rw = Evaluate("MAX(IF(" & [rng].Address & "<>"""",row(" & [rng].Address & ")))") cmn = Evaluate("MAX(IF(" & [rng].Address & "<>"""",column(" & [rng].Address & ")))") -- isabelle Le 2012-04-28 08:21, T2B a écrit :
T TG Apr 30, 2012 #3 r = activesheet.usedrange,row c = activesheet.usedrange.column /Tommy hi, rw = Evaluate("MAX(IF(" & [rng].Address & "<>"""",row(" & [rng].Address& ")))") cmn = Evaluate("MAX(IF(" & [rng].Address & "<>"""",column(" & [rng].Address & ")))") -- isabelle Le 2012-04-28 08:21, T2B a écrit : In VBA for a named range, I need to return: Click to expand... row count, last occupied cell column count, last occupied cell Click to expand... Thanks. Click to expand... Click to expand...
r = activesheet.usedrange,row c = activesheet.usedrange.column /Tommy hi, rw = Evaluate("MAX(IF(" & [rng].Address & "<>"""",row(" & [rng].Address& ")))") cmn = Evaluate("MAX(IF(" & [rng].Address & "<>"""",column(" & [rng].Address & ")))") -- isabelle Le 2012-04-28 08:21, T2B a écrit : In VBA for a named range, I need to return: Click to expand... row count, last occupied cell column count, last occupied cell Click to expand... Thanks. Click to expand... Click to expand...
