macro copy, how to remove formatting?

new to the macro VB area, got my copy range of cells to work but I'd like to remove all the formating so its just standard text.

As it stands, I have to paste the data into Note Pad to put it in standard line by line text.

the problem is it is pasted into windows live mail with tabs at the end of each line and line breaks where there shouldnt be any.


anyone help me figure this pickle out?

thanks

Is this what you mean? This will paste it into the cell and whatever default formatting is in that cell will remain. You could also paste the cells and then have your macro re-format the cells to whatever format you desire. You can't just get rid of formatting. There has to be some sort of definition of font.

Please Login or Register  to view this content.

ohhh ok, i get a piece of the picture now.

what about general formating? is there a way to just format a range of cells to general format?

is there an argument i can combine with paste special to assign a general format rule for all cells copied into the clipboard?

i was going to search on format in the forums but im a complete n00b to Visual Basic ... but without knowing what term to search for besides format and paste special, i imagine i'd be looking through tousands of topics? heh.


man im such an00b

Originally Posted by shg

Or just

Please Login or Register  to view this content.

Normal needs to be in quotation marks.

Thanks for posting though. That is much simpler than what I recorded.

ok.
thats helps a great deal, i appreciate it.