| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assign Cell Values without a Loop
Seems like that would have been easy enough to test instead of waiting more
than half an hour for me to tell you "Yes, that appears to work". However, I think my preference would be to do it this way though... Sheets(1).Range("B2:B10").Copy Sheets(2).Range("B2") or, if you prefer, this the more self-documenting form... Sheets(1).Range("B2:B10").Copy Destination:=Sheets(2).Range("B2") Rick "BHatMJ" wrote in message ... Thank you both. If I took that a step further, would it be valid to have the following command also? Sheets(1).Range("B2:B10").value = Sheets(2).Range("B2:B10").value "Rick Rothstein (MVP - VB)" wrote: Range("B2:10").value = "abc" Typo alert... Bob accidentally left out the column designation for the ending cell of the range... Range("B2:E10").Value = "abc" Rick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to assign values to a cell based on values in another cell? | Excel Worksheet Functions | |||
| Cannot assign a range to seriecollection values | Charts and Charting in Excel | |||
| Assign values to text | Excel Worksheet Functions | |||
| In Excel how can I assign values to a Yes or No question with IF | Excel Discussion (Misc queries) | |||
| Assign values to text within a cell | Excel Worksheet Functions | |||
![Rick Rothstein \(MVP - VB\)[_567_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
