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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
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
210
steallan
S
D
  • Question
Find text in one cell and add data to the cell below it
Replies
7
Views
273
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
606
K0st4din
K0st4din
C
  • Solved
Select all cells below a continuous range to delete
Replies
2
Views
442
cyburban
C
B
  • Question
Can't Exit Desing Mode because Control 'xxxx' can not be created
Replies
1
Views
218
ktwwtk
K

Forum statistics

Threads
1,214,641
Messages
6,120,693
Members
448,979
Latest member
DET4492

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