LinkBack URL
About LinkBacks
i need a macro to Find last row with data and autofit, bold and center align all the cells in the row
i need a macro to Find last row with data and autofit, bold and center align all the cells in the row
Last edited by daillest319; 02-24-2012 at 11:32 AM.
daillest319,
Here's a simple code that may help you.
Please Login or Register to view this content.
Charles
There are other ways to do this, this is but 1 !
Be Sure you thank those who helped.
IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.
To find the last row of column A - you can use this code lineTo autofit -Please Login or Register to view this content.To bold and center align, all you need to do is just record the action and you will get the code.Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks i started using this code but cant seem to figure out how to make not only look just in column A but in all columns for the last row becuase some of the cells have empty data. For example the last row had A,B,C etc blank and the data starts at column G.
Please Login or Register to view this content.
Hi,
Your code
TryPlease Login or Register to view this content.
But the code provided my myself and arlu1201 should do the job.Please Login or Register to view this content.
You can also use this -You can also specify the sheet instead of Activesheet.Please Login or Register to view this content.
thank you all for all yuor help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks