| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a String to a Range
Hi
Basically, I just want to know if there is any (easy) way of changing a string (as in, a cell in Excel contains a 3D cell range as text) to the appropriate range. So, in cell K12 I have the following text : 'Quarter 1 Contract 03'!C12,'Quarter 1 Spot 03'!C12,'Quarter 2 Contract 03'!C12,'Quarter 2 Spot 03'!C12,'Quarter 3 Contract 03'!C12,'Quarter 4 Contract 03'!C12,'Quarter 4 Spot 03'!C12 And I want to change this to a range in VBA so I can COUNTIF (cells < 0)! If I havent explained properly, say and I'll try harder! Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing a String to a Range
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the range for averages with out changing the formula. | Excel Worksheet Functions | |||
| changing the order of text in a string | New Users to Excel | |||
| changing text values to a different string | Excel Worksheet Functions | |||
| Translate range name passed as string to a custom function to range addresses! | Excel Programming | |||
| Passing a String in Array to Range as String | Excel Programming | |||
Linear Mode
