Assignning a value to a range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi
try
Worksheets("Sheetname").Range("U19").value = ""

or
Worksheets("Sheetname").cells(19,21).value = ""

--
Regards
Frank Kabel
Frankfurt, Germany

BEn said:
How to I assign a single value to a specif selected range in code
Click to expand...
some thing like this but this wont work?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named ranges disappearing in Excel 2007 2
Set range, perform operation, set new range, repeat 1
Graph with variable range 2
Where am I going wrong? Cells reference to a range appears to havestopped working! 5
sorting a worksheet with vb code 2
Assign variable value across files 1
Problem copying table data as a picture onto chartsheet 6
Run Macro If Cell have "x" value 0

Back
Top