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