every macro i record is deleting all of my data

J

jcbrookshi

New Member
Joined
Mar 6, 2019
Messages
1
I'm attempting to create a macro that formats a worksheet of raw data. The macro is deleting unneeded columns, wrapping text, selecting page size and margins for printing etc. There are no formulas in this data. Once I record the macro and go back to test it, it formats the columns and page size etc. but it deletes the data everytime. I have made several attempts and I get the same result. I don't understand VBA and have no resources here at work that can help. PLEASE HELP!!
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Sort by date Sort by votes
Hi & welcome to MrExcel
Can you please post your code?
Also do you have any merged cells?
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Macro: flatten sheet, delete other tab, and save
Replies
4
Views
224
steallan
S
D
  • Question
Find text in one cell and add data to the cell below it
Replies
7
Views
331
rlv01
R
K0st4din
  • Solved
How do I automate macros to be placed in many workbooks that won't be on my PC
2 3 4
Replies
33
Views
702
K0st4din
K0st4din
C
  • Solved
Select all cells below a continuous range to delete
Replies
2
Views
459
cyburban
C
B
  • Question
Can't Exit Desing Mode because Control 'xxxx' can not be created
Replies
1
Views
242
ktwwtk
K

Forum statistics

Threads
1,215,373
Messages
6,124,548
Members
449,170
Latest member
Gkiller

Share this page

We've detected that you are using an adblocker.

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.
Go back
Back
Top