MACRO - Create worksheet adding an apostrophe

[PaulaGon]

Hi, I need some help with a problem that I am trying to solve. I hope someone can help me!

I found two macros that I need to use one after another : one that creates a new Worksheet only with values (without formulas), and another macro that adds an apostrophe (') at the beginning of each cell, (so I can convert several columns to text).

Is there any way to create a single macro that creates a new worksheet, without the formulas but with an apostrophe (') at the beginning of each cell?

MACRO 1 (create new worksheet)

Please Login or Register  to view this content.

MACRO 2 (add an apostrophe)

Please Login or Register  to view this content.

Any suggestions would be greatly appreciated!!!

[davesexcel]

ActiveSheet.copy, creates a workbook with 1 sheet only(with the copied sheet) you do not need to loop through the sheets as there is only one sheet.

You can change the cell formatting to text

Please Login or Register  to view this content.

[PaulaGon]

Hi,

But I really need that all the values have an apostrophe at the begginning (') is necesary to import this excel file to an aplication i have....

I tried to create a macro that call the two macros but also does not work...I think the problem is the first macro creates a new worksheet only with values and the second macro do not work in this new worksheet..

Is posible to make a macro that creates a new worksheet only with values but with an apostrophe at the beginning?

Thanks in advanced!

[davesexcel]

Is your code not working?

[PaulaGon]

Hi,

No, is not working ...when I call the two macros, appears an error and it doesn´t work....Creates the new worksheet but it doesn´t put the apostrophe at the beginning...

[davesexcel]

Can you try this:

Please Login or Register  to view this content.