Dynamic variables

[rhinhart]

hi all, I am working on a project which I wrote repeatedly "Sheets(x).Cells(i,n)" and "Sheets.Cells(j,m)"

where x, y, n and m are constants, while i and j are loop variables.

After a while, I am lost on which is which. Hereby I want to create two variables, preferably named "targetCell" and "curCell" where
targetCell = Sheets(x).Cells(i,n)
curCell = Sheets.Cells(j,m)

Is there anyway I can define those outside the loop so targetCell and curCell values changes whenever i and j changes?

I tried to search the forum with keyword "dynamic variables", but maybe I use the wrong keyword and did not found any good help. Please pardon me if this is a duplicate question and if anyone can provide a link to the post it will be great.

Thank you in advance for your help.

 

[JLGWhiz]

hi all, I am working on a project which I wrote repeatedly "Sheets(x).Cells(i,n)" and "Sheets.Cells(j,m)"

where x, y, n and m are constants, while i and j are loop variables.

After a while, I am lost on which is which. Hereby I want to create two variables, preferably named "targetCell" and "curCell" where
targetCell = Sheets(x).Cells(i,n)
curCell = Sheets.Cells(j,m)

Is there anyway I can define those outside the loop so targetCell and curCell values changes whenever i and j changes?

I tried to search the forum with keyword "dynamic variables", but maybe I use the wrong keyword and did not found any good help. Please pardon me if this is a duplicate question and if anyone can provide a link to the post it will be great.

Thank you in advance for your help.

They have to be defined after the values they contain are initialized, otherwise they will be empty. So I would say they need to be defined inside the loop.

 

[rhinhart]

They have to be defined after the values they contain are initialized, otherwise they will be empty. So I would say they need to be defined inside the loop.

Thank you for your information.
Is there anyway to define it as a pointer or something else? There is actually much more than those two I mentioned above.

 

[mikerickson]

Excel variables do not create references the way that you want.

 

[JLGWhiz]

Thank you for your information.
Is there anyway to define it as a pointer or something else? There is actually much more than those two I mentioned above.

I'm not sure exactly what you are trying to do. Have you looked at using a public variable? It can change value and still be used throughout the code, but it gets a little tricky if you are not keeping a close watch on how you write the code. The programmer has to know what the public variable is when they use it in the code. Otherwise, you get some undesired results.