Macro won't work twice

[kmlloyd]

I have the following macro that I use to convert numbers stored as text to text. For some reason, if I try to use it twice in a row, it won't work, I get an error that says "application-defined or object-defined error" and highlights this part of the code:

Cells.SpecialCells(xlCellTypeLastCell) _
.Offset(1, 1).Copy

Please Login or Register  to view this content.

[pike]

Hi kmlloyd
strange works twice for me

[kmlloyd]

That's very strange.

It seems to be when I'm selecting an entire column....does that make a difference?

[pike]

try..

Please Login or Register  to view this content.

[shg]

Or ...

Please Login or Register  to view this content.

[kmlloyd]

Thanks everyone!