Using counter as cell reference

Hi,

I'm trying to run a program that goes down row by row, checks if two values are equal, and if not, replaces the second value with the first.

I currently have a for loop set up as follows:

Please Login or Register  to view this content.

It checks the values correctly, but right now it just outputs the range A1:I1 5 times. I want it to output a range Ai:Ii, where i is the integer I'm using for my for loop.

Is this possible?

Thanks in advance for your help.

Hi and welcome to the forum. Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Since this is your first post I'll add them for you but please remember for the future.

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

You may not of course need a loop. It's possible you could do this with regular functions and avoid VBA altogether.

...forgot to mention you don't need .Select which should generally be avoided since it's rarely necessary and just adds a time overhead.

Please Login or Register  to view this content.

And one more tip, try to avoid code like Worksheets("Sheet1") and use the VBA sheet code name. e.g

Please Login or Register  to view this content.