How to setup the ROW number as a VARIABLE within a RANGE

[nenadmail]

This is part of my code here:

Please Login or Register  to view this content.

I want the ROW NUMBER to be referenced as "xyz" in my code.
But DEBUG error comes up and highlights THIS portion when the MACRO is run.

Please Login or Register  to view this content.

I think it's because THIS part is written wrong:

Please Login or Register  to view this content.

I don't know how to correct it!

Thanks!

[MaczaQ]

hi,
try one from below examples

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[nenadmail]

Ok so I tried this:

Please Login or Register  to view this content.

And it brings a DEBUG error and highlights: Set ord = Intersect(.Rows(xyz), .Range("AA:AF"))


I also tried this:

Please Login or Register  to view this content.

And in the DEBUG error it highlights this: Set ord = Sheets("Image Catalog").Range("AA" & xyz & ":AF" & xyz)


I don't get it... what's wrong?

[patel45]

explain better what do you want, attach a sample

[jason.b75]

Some of your declaration types are wrong,

Try

Please Login or Register  to view this content.

or an alternative would be

Please Login or Register  to view this content.

[nenadmail]

OK I figured it out....

I got it to work this way (referencing the row number to a cell "AD1") Which is an even better solution for my project !!

Please Login or Register  to view this content.

AND the "AD1" has a MATCH formula looking for the product id and identifying what row it's in:

Please Login or Register  to view this content.

So looks like your code was fine! The problem was in the original: Set xyz = Rows(13)
That's what it didn't like.


Thanks for your help!!
The important thing is it works great now!