PDA

View Full Version : Couple of Simple VBA Questions



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