Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that moves to a cell using two variables See below
Just when I think I know what I'm doing something like this comes along! I
have a macro that needs to move to a cell based on input from the user. The vaiables are set and working. So What I need to do is set the active cell as the Rows,Columnx. Can anyone help me with this. I keep getting " Run Time Error 1004" "Range' of object '_Global failed" Here is the line: Range(Rows, columnx).Select Both the Rows and Columnx variables are working when I run the macros step-by-step mode. Any help would be appreciated! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that moves to a cell using two variables See below
Rows is a reserved word. Try using a different name for your varaible like
lngRows (assuming you have declared the varaible as type Long). -- HTH... Jim Thomlinson "Mathew" wrote: Just when I think I know what I'm doing something like this comes along! I have a macro that needs to move to a cell based on input from the user. The vaiables are set and working. So What I need to do is set the active cell as the Rows,Columnx. Can anyone help me with this. I keep getting " Run Time Error 1004" "Range' of object '_Global failed" Here is the line: Range(Rows, columnx).Select Both the Rows and Columnx variables are working when I run the macros step-by-step mode. Any help would be appreciated! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that moves to a cell using two variables See below
Here is a typical way of getting somewhe
Sub get_there() cl = Application.InputBox("enter column (A,B,...)") rw = Application.InputBox("enter row (1,2,3...)") addrs = cl & rw Range(addrs).Select End Sub -- Gary''s Student - gsnu200743 "Mathew" wrote: Just when I think I know what I'm doing something like this comes along! I have a macro that needs to move to a cell based on input from the user. The vaiables are set and working. So What I need to do is set the active cell as the Rows,Columnx. Can anyone help me with this. I keep getting " Run Time Error 1004" "Range' of object '_Global failed" Here is the line: Range(Rows, columnx).Select Both the Rows and Columnx variables are working when I run the macros step-by-step mode. Any help would be appreciated! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that moves to a cell using two variables See below
Gary's Student: Tried this and it did not work. I also changed the variable
names. Here is what I have: I have a variable named IngRowsxy which equals an integer between 13 and 31 depending on several other options selected. The macro is assigning the correct value to this variable. The other variable is columnxy which is either 4 or 5. This is also working correctly. I used the step-by-step execution of the macro to verify this. However, when I try to use the Range(columnxy, IngRowsxy).Select I get the error. I also tried this: Range(columnxy IngRowsxy).Select So with your code, below I tried: addrs = IngRowsxy & "," & columnxy Range(addrs).Select and when that failed I tried: addrs = IngRowsxy & columnxy Range(addrs).Select Neither of these worked! Any help would be appreciated. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that moves to a cell using two variables See below
Give this a try...
Cells(IngRowsxy, columnxy).Select Range takes up to 2 arguments. Each argument is a cell or cell address. Your code supplies the references to a single cell. You want to use Cells for that... -- HTH... Jim Thomlinson "Mathew" wrote: Gary's Student: Tried this and it did not work. I also changed the variable names. Here is what I have: I have a variable named IngRowsxy which equals an integer between 13 and 31 depending on several other options selected. The macro is assigning the correct value to this variable. The other variable is columnxy which is either 4 or 5. This is also working correctly. I used the step-by-step execution of the macro to verify this. However, when I try to use the Range(columnxy, IngRowsxy).Select I get the error. I also tried this: Range(columnxy IngRowsxy).Select So with your code, below I tried: addrs = IngRowsxy & "," & columnxy Range(addrs).Select and when that failed I tried: addrs = IngRowsxy & columnxy Range(addrs).Select Neither of these worked! Any help would be appreciated. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that moves to a cell using two variables See below
Jim: Thanks for the help: I changed the variable type to interger and the
new code with cells worked! Again Thanks! "Jim Thomlinson" wrote: Give this a try... Cells(IngRowsxy, columnxy).Select Range takes up to 2 arguments. Each argument is a cell or cell address. Your code supplies the references to a single cell. You want to use Cells for that... -- HTH... Jim Thomlinson "Mathew" wrote: Gary's Student: Tried this and it did not work. I also changed the variable names. Here is what I have: I have a variable named IngRowsxy which equals an integer between 13 and 31 depending on several other options selected. The macro is assigning the correct value to this variable. The other variable is columnxy which is either 4 or 5. This is also working correctly. I used the step-by-step execution of the macro to verify this. However, when I try to use the Range(columnxy, IngRowsxy).Select I get the error. I also tried this: Range(columnxy IngRowsxy).Select So with your code, below I tried: addrs = IngRowsxy & "," & columnxy Range(addrs).Select and when that failed I tried: addrs = IngRowsxy & columnxy Range(addrs).Select Neither of these worked! Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel macro which prompts for input and moves to a cell - repeated | Excel Worksheet Functions | |||
naming range moves me to macro | Excel Programming | |||
Macro moves data and more!!! | Excel Programming | |||
Hyperlink-link so that when a cell moves the link also moves? | Excel Programming | |||
Macro That Moves Cursor Down | Excel Programming |