[SOLVED] VBA Macro : copy cell content between worksheets

[giovanni18]

Hello everybody,

I can not get this simple piece of VBA code working.
I have a file named macro_ins_formula.xlsm which has
two worksheets : "Sheet1" and "Sheet2"

Please Login or Register  to view this content.

Thank you, regards
giovanni

macro_ins_formula.xlsm

[xladept]

Maybe:

Please Login or Register  to view this content.

[patel45]

your goal is not clear for me, you have a text in B3, however the correct sintax is

Please Login or Register  to view this content.

when you are using VBA you have to use english sintax, not italian.

[Norie]

Giovanni

I think you might need to write the formula in English.

What is the formula anyway?

I think TESTO is TEXT but normally that would have a 2nd argument for formatting.

[giovanni18]

Hello patel, thank you it works fine now.

The goal may be not clear as the piece of code
is intended to be used in a more complex contest.

Sorry for the missed function translation!
Of course better in english so evryone understand!

2 answer in 15 min. its really not bad..I like this place