how to select a range by row and column

[jamiguel77]

hi i try:


MyRange = NewSheet.Range(NewSheet.Cells(wrenHojaNuevaTop, wyi), NewSheet.Cells(wrenHojaNuevaTop- 1, wyi))

wrenHojaNuevaTop=2
wrenHojaNuevaTop=3

but not work, note NewSheet Exist... isnt the problem....


thanks any advice?

 

[footoo]

Set MyRange =

Also, what value has been assigned to the variable NewSheet ?

 

[Trebor76]

Any what value are you assigning to your variable wyi?

 

[AndyMachin]

To answer the question in the post title "how to select a range by row and column"

Here are some codes you may find useful:

Select by rows:

Sub ByRow()Range("1:10").Select
End Sub

Select by columns:

Sub ByCol()Range("A:E").Select
End Sub

Both:

Sub Both()Range("A1:E10").Select
End Sub

You can even use variables

By rows:

Sub ByRow()
Row1 = 1
Row2 = 10
Range(Row1 & ":" & Row2).Select
End Sub

By Columns:

Sub ByCol()
Col1 = "A"
Col2 = "E"
Range(Col1 & ":" & Col2).Select
End Sub

Or both:

Sub Both()
    Row1 = 1
    Row2 = 10
    Col1 = "A"
    Col2 = "E"
        Adrs = Col1 & Row1 & ":" & Col2 & Row2
Range(Adrs).Select
End Sub

 

[jamiguel77]

hi thanks for answer..... the Set solved my problem.....

thanks