Thread: Hide rows without data in a column based on active cell
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
[email protected] koperstexdq_dont_use@gmail.com is offline
external usenet poster
  
Posts: 28
Default Copy text in colum each time it is a new text
The macro does exactly what I want. Thank you very much.
But can I define the range to be looked through?
I tried to insert this in the macro, but it did not work.
Range("A6:C48").Select

Best regards,
Kaj Pedersen
Reply With QuoteReply With Quote