Macro that moves to a cell using two variables See below

[Guest]

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!

 

[Guest]

Rows is a reserved word. Try using a different name for your varaible like
lngRows (assuming you have declared the varaible as type Long).

 

[Guest]

Here is a typical way of getting somewhere:

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

 

[Guest]

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.

 

[Guest]

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...

 

[Guest]

Jim: Thanks for the help: I changed the variable type to interger and the
new code with cells worked! Again Thanks!