View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Assignning a value to a range

One way:

Sheets("Sheetname").Cells(19, 21).ClearContents


In article ,
BEn wrote:

How to I assign a single value to a specif selected range in code some thing
like this but this wont work?

Worksheets("Sheetname").Range("19R:21C").value = ""

Thankyou in advance for you help.