Thread: Can I get VBA script to read a word with both lcase and ucase lett
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Can I get VBA script to read a word with both lcase and ucase
One way:
Selection.Offset(1, -2).value = ""

Calle wrote:

ok, thx I try that. one more question. Is ther a way to get a script to
delete content in merged cells. I can only get the script to delete in
normal cells.

script:

Case Is = "i17"
If LCase(.Value) = LCase("clear") Then
Selection.Offset(1, -2).ClearContents
Else

--

Dave Peterson
Reply With QuoteReply With Quote