Justinbodden
09-22-2015, 05:00 AM
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
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