📊 Excel & Spreadsheets Prompts
Formulas, reports, pivot tables, charts, VBA macros
← All Categories
2 prompts
in VBA & Macros
Auto-Send Email Report VBA
Write an Excel VBA macro that: 1) Takes data from the active sheet, 2) Creates a formatted HTML email in Outlook, 3) Attaches the current workbook as a PDF, 4) Sends it to a specified email address. Include error handling, a progress message box, and comments explaining each section. The email should have a professional template with the report date in the subject line.
💡 Test with a DisplayEmail line first instead of Send to preview before auto-sending.
Auto-Format New Data VBA
Write a VBA macro that automatically formats any new data pasted into an Excel sheet: 1) Auto-fit column widths, 2) Add borders to all cells with data, 3) Bold the header row, 4) Apply alternating row colors (light gray/white), 5) Freeze the top row, 6) Auto-apply number format to columns containing numbers, 7) Add filters to the header row. The macro should detect the data range automatically.
💡 Assign this macro to a button on the sheet for one-click formatting.