Populating a range

  • Thread starter Thread starter Nigel Bennett
  • Start date Start date
N

Nigel Bennett

When a user selects an item from a list box I would like
it to go and select and range of numbers from a sheet and
insert it in the box, I tried doing this

Sheets("Book vs Plan").Range("d50:o50") = Sheets
("plan").Range("d4:o4")

but that failed, no error messages but no data either.

Can someone help me with the correct syntax

Thanks
 
Perhaps if you explain your problem a little more clearly ...
 
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

Populating a Range by Code 2
Range(sheet2) = Range(sheet1) 11
File Name changes with dates and Deleting Rows of Zeros 0
Reduce Numbers Down To A Specific Value 1
Run macro from active workbook whose name keeps changing 20
Populate combo box with a range 5
Find the correct sheet then find a value on that sheet 8
Named Ranges in various sheets 1

Back
Top