How to use name range..Please help to solve this issue..
Solved/Closed
mathewmunna
Posts
22
Registration date
Tuesday November 18, 2014
Status
Member
Last seen
May 21, 2015
-
Apr 27, 2015 at 01:51 AM
Mathewmunna - May 7, 2015 at 02:19 AM
Mathewmunna - May 7, 2015 at 02:19 AM
Related:
- How to use name range..Please help to solve this issue..
- Apple airtag range - Guide
- Wimax frequency range - Guide
- If function with date range - Guide
- Laptop low range - Keyboard Forum
- Personal area network range - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
May 4, 2015 at 12:03 PM
May 4, 2015 at 12:03 PM
Hi Mathew,
Try the following code and see if we are on the right track.
Don't forget to save before running the code, so you can reload your file when some data might be overwritten.
Here is the code:
Best regards,
Trowa
Try the following code and see if we are on the right track.
Don't forget to save before running the code, so you can reload your file when some data might be overwritten.
Here is the code:
Sub RunMe()
Sheets("Page1").Select
For Each cell In Range("A1:A5")
Application.Goto Reference:=cell.Value
If Sheets("Page2").Range("A1") = vbNullString Then
Selection.Copy Sheets("Page2").Range("A1")
Else
Selection.Copy Sheets("Page2").Cells(1, Columns.Count).End(xlToLeft).Offset(0, 1)
End If
Next cell
End Sub
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 30, 2015 at 11:41 AM
Apr 30, 2015 at 11:41 AM
Hi Matthew,
So you want to compare a single cell to a range of cells. Per definition they can never be equal. So when will they be equal according to you?
Best regards,
Trowa
So you want to compare a single cell to a range of cells. Per definition they can never be equal. So when will they be equal according to you?
Best regards,
Trowa
exactly page1 is input lets consider column A ... i.e a1 to a5 i will give input
like rng1, rng3, rng4, rng2, rng5. i already have named ranges(rng1, rng2..rng5) with different number of columns but equal rows. what i need output is on page2
using the input cells i.e a1= rng1 then start from cell a1.. name range i.e predefined rng1(eg: i defined on page1,G1:J6 as name range i.e "rng1", K1:M6 as "rng2", N1:Q6 as "rng3") output should be on page2 cells A1:D6 show values on "rng1" continuing E1:G6 show values on "rng3" (i.e values on K1:M6, reffering given input on page1 cell a2) and should continue checking till a5 on page1.. Hope u understand my complex reply..
Thanks TrowaD
With regards,
Mathew
like rng1, rng3, rng4, rng2, rng5. i already have named ranges(rng1, rng2..rng5) with different number of columns but equal rows. what i need output is on page2
using the input cells i.e a1= rng1 then start from cell a1.. name range i.e predefined rng1(eg: i defined on page1,G1:J6 as name range i.e "rng1", K1:M6 as "rng2", N1:Q6 as "rng3") output should be on page2 cells A1:D6 show values on "rng1" continuing E1:G6 show values on "rng3" (i.e values on K1:M6, reffering given input on page1 cell a2) and should continue checking till a5 on page1.. Hope u understand my complex reply..
Thanks TrowaD
With regards,
Mathew
May 7, 2015 at 02:19 AM