Thread: Registrate date/time in a specific column for multiply selected rows
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Registrate date/time in a specific column for multiply selected rows
Hi Johan,

Am Mon, 16 Oct 2017 05:39:11 -0700 (PDT) schrieb :

It deletes only 'xyz' in the selected rows and not in the complete column FA

change the code to:

Set myRng = Columns("FA")
myRng.Replace what:="xyz", replacement:=""


Regards
Claus B.
--
Windows10
Office 2016
Reply With QuoteReply With Quote