anandbohra
07-05-2007, 10:09 PM
Hi All,
Pl help me in getting total columns used in my worksheet through VBA code.
i got how to count total used rows but not getting for total column used.
the code for total rows used in sheet is
testrow = activesheet.Cells(Rows.Count, 1).End(xlUp).Row
pl tell me the code in same way for getting total column used in sheet
awaiting for your reply.
Pl help me in getting total columns used in my worksheet through VBA code.
i got how to count total used rows but not getting for total column used.
the code for total rows used in sheet is
testrow = activesheet.Cells(Rows.Count, 1).End(xlUp).Row
pl tell me the code in same way for getting total column used in sheet
awaiting for your reply.