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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
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
216
steallan
S
D
  • Question
Find text in one cell and add data to the cell below it
Replies
7
Views
304
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
656
K0st4din
K0st4din
C
  • Solved
Select all cells below a continuous range to delete
Replies
2
Views
451
cyburban
C
B
  • Question
Can't Exit Desing Mode because Control 'xxxx' can not be created
Replies
1
Views
231
ktwwtk
K

Forum statistics

Threads
1,215,036
Messages
6,122,796
Members
449,095
Latest member
m_smith_solihull

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