Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creation of a range with no specified address
Hello
Somone knows how can i set a range (with the same property an actions) ,defining the number of cell but not defining where it will b located? eg: a window (2X2) wich the cell(1,1) is fixed "my name" I am trying this Function windowx(cellx) As Range cellx.Value = "myname" Set windowx = Range(cellx, celx.Offset(1, 1)) End Function and i am getting " object required" All help wiil be welcome thank yo -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creation of a range with no specified address
We do not normally use UDFs to perform actions but to return values. S
I have used a subroutine. :- '================================= Dim Mywindowx As Range '------------------- Sub test() windowx Application.ActiveCell MsgBox (Mywindowx.Address) End Sub '-------------------- '- Sub windowx(cellx As Range) cellx.Value = "myname" Set Mywindowx = Range(cellx, cellx.Offset(1, 1)) End Sub '================================= -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creation of a range with no specified address
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? | Excel Worksheet Functions | |||
How to create a range address with ADDRESS function? | Excel Worksheet Functions | |||
Address Range | Excel Worksheet Functions | |||
Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) | |||
range.address ? | Excel Programming |