wont delete data in column

ADRIANA P
ADRIANA P used Ask the Experts™
on
In this workbook columns B and M are getting deleted

need stay after hit the o convert button
2N_to.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Try this.
29121018.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
i get thisxxx1111.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
when hit generate 0
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
How did that happen???  Change that line to
Activesheet.Range("C2:L" & lngLastRow).Clear

Open in new window

ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
i did but it change the date
zzzz1111.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
date should stay as original input
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Two really strange things. Corrected.
29121018a.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Good going !

Great Expert!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial