Thread: Splitting one column into multiple columns
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Painter
 
Posts: n/a
Default Splitting one column into multiple columns
Thanks Toppers,

However, this presented a problem (runtime error 1004):

..Cells(sr + 1, 1).Resize(r - sr - 1, 1).Copy orng.Offset(1, 0)

Did I forget to customize something?

PM

Reply With QuoteReply With Quote