I have a macro that I recorded to copy columns E-H, and paste values, then delete columns L-R.
The problem that I am having is when I run the macro, instead of pasting values on just E-H, it pastes the values for A-K. I have formulas in some of the other columns that I need to stay as...
Hi,
I have been trying to record a macro to do the following:
1. Create a new column (always before the last column of the table)
2. Drag the formula from the previous column to the new one.
Example:
Columns: A, B, C, D, E
Need to create a new column always before the last column (E) so...
I want to record a macro for adding a shape (arrow) and then adding black squares into the shaft of the arrow. Finally to group all and rename the group. Such things were simple in excel 2003 but nothing is recorded in excel 2007. Has the ability to record a macro involving shapes been removed...
So I have recorded a macro that filters for certain criteria in a master list of projects, then copies the projects that meets this criteria and pastes it into a timeline in another worksheet. However, because the list of projects gets bigger and smaller when the filter criteria changes, right...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.