Paste text from webpages into cells and keep formats
Subject basically says it all... I always get new formats (frames,
alignment etc.). Is there a way for the whole Excel sheet to only paste the contents and not having to go via the right click menu + dialog to paste only the contents? I'm collecting data for an application like addresses, emails, URLs and it's pretty annoying that the formats are changed every time when pasting. Maybe there's an option that I can't find?? TIA Karsten |
Paste text from webpages into cells and keep formats
it's pretty annoying that the formats are changed every time when pasting.
Agreed but I don't a way to get Excel to default to destination format. I recorded a macro while pasting and switching to destination format and I got this, which seems to do the job: Sub Macro1() ActiveSheet.PasteSpecial Format:="HTML", Link:=False, DisplayAsIcon:= _ False, NoHTMLFormatting:=True End Sub -- Jim "Karsten Wutzke" wrote in message ... | Subject basically says it all... I always get new formats (frames, | alignment etc.). | | Is there a way for the whole Excel sheet to only paste the contents | and not having to go via the right click menu + dialog to paste only | the contents? | | I'm collecting data for an application like addresses, emails, URLs | and it's pretty annoying that the formats are changed every time when | pasting. | | Maybe there's an option that I can't find?? | | TIA | Karsten |
All times are GMT +1. The time now is 07:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com