| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a new range from existing range
Hi,
I am writing a user defined function with a range as one of the arguments e.g. N4:N14. While executing the function, I need to find out cells in column x units away e.g. when x = 1 output should be O4:14 or when x =2 output should P4:P14. I need to assign new range to a variable of type range. I am new to VBA. Can you help me? Sachchi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add an apostrophy to a range of existing cells? | Excel Worksheet Functions | |||
| Delete Rows based on not existing in range | Excel Programming | |||
| Create/copy combo boxes in one range if condition is met in a different range | Excel Programming | |||
| Add a Range to an existing Range in a loop? | Excel Programming | |||
| Open only existing Excel Files in a given Range | Excel Programming | |||
Threaded Mode
