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
[VBA] testrow = activesheet.Cells(Rows.Count, 1).End(xlUp).Row[/VBA]
pl tell me the code in same way for getting total column used in sheet
awaiting for your reply.
[VBA]ActiveSheet.Cells(1, Columns.Count).End(xlToLeft).Column[/VBA]
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
thanks johnske
actually i was using xlleft instead of xltoleft & hence continuously getting error.
thanks for such quick reply.
That's a very common mistakeOriginally Posted by anandbohra
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
Posting Permissions
Reply With Quote
