-
Couple of Simple VBA Questions
Hi Vba Community-
I hope everyone is well.
I have only begun to play with VBA and need some help.
I have to format a report on a weekly basis and I was hoping someone could help me automate this. See below for the formatting:
- Find rows with valuable data (not including title of worksheet located at A1:A4) and I need all of these rows rows to have a 33' height.
- How do i find the last row with data?
- Find columns with valuable data (not including title of worksheet located at A1:A4) and I need all of these columns to have a 15' Width.
- How do I find the last column with data?
- I need to include a page # footer.
- Landscape Portrait
- All Text has to be centered.
- I need to delete all columns that have the words "QTY" or "Ticket"
- Print titles need to be 5:6
- Freeze panes at row 6.
If anyone could help with any of these that would be greatly appreciated. I figured I can just play with VBA after and move forward from there.
Best,
JB
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules