AxeTracks
asked on
Excel 2010 VBA macro
I have a spreadsheet with 12 columns, the last column is a date. I want to scan down this column and when the date changes, i want to insert an empty row. The empty row will be used to sum the columns for that day.
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
try this
Sub InsertMania()
'Insert row above active cell
ActiveCell.EntireRow.Inser
'Insert row below active cell
ActiveCell.Offset(1).Entir
'Insert column to the left of the active cell
ActiveCell.EntireColumn.In
'Insert column to the right of the active cell
ActiveCell.EntireColumn.Of
End Sub
by
kumaresan