clearing format

[kenguru]

I have this line:
ActiveSheet.Rows(ii + 1).EntireRow.Insert

but when i insert the line, than the format is of the next line. How can i clear the format of the line?

So, i want to copy the following number "0734" (0 from the begining is important) but when i copy it becames "734" and this is a big problem for me

Thank you !

 

[kenguru]

I realised what is causing the problem, only i don't know how to fix it:
first i save the value of the "0734" in a parameter, that i insert the row, and after that i copy in the row the value. So i think the excel makes a paste by value and not a simple paste in this way

 

[xlbo]

You need to format the inserted row as text 1st - then paste



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question