View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default Macro to remove squares from cells

On Aug 16, 9:29*am, "Alonso"
wrote:
1. after conversion pdf document to xls file, there is a small square
symbol(tab) in many cells inside this excel file: how to remove it all at
once? (with some option or via macro). Excel 2003.

2. how to join a few excel sheet (inside one excel file) into one sheet?
(table with data was splitted into few worksheets)

*thank you!

try

SUB noshapes()
for each sh in activesheet.shapes
sh.cut
next
end sub