Is there a way to Set Desination with a variable?

[FanAnd22]

Hi guys, im just having a bit of trouble with my code.

I have code that outputs data into a cell.

Originally it was coded with:

Please Login or Register  to view this content.

and it worked perfectly.

But i realised that i need it to output data in other columns too so that each result would be under its appropriate column.

and so i tried doing this

Please Login or Register  to view this content.

but i kept getting an error message that said
"duplicate delcaration" and it highlighted the line

Please Login or Register  to view this content.

I guess this means im declaring "x" in the "Set destination" line aswell.

My intention was to make it a variable so i could put it in a loop and each result could be placed in its relevant column. but im stuck at this issue. Ive been looking for an answer for a few hours and cant come up with a way of doing it. Is there a way i can work around this?

Thank you for any help.
kind regards.

[vba_php]

the reason you're getting the error is because you are using ''x'' twice. it doesn't matter where it's at. I believe, the option explicit statement in that language requires a coder to write dim [var] as [type] when declaration variables. if you don't write that, you can use anything in code without issuing a formal declaration.

[FanAnd22]

the reason you're getting the error is because you are using ''x'' twice. it doesn't matter where it's at. I believe, the option explicit statement in that language requires a coder to write dim [var] as [type] when declaration variables. if you don't write that, you can use anything in code without issuing a formal declaration.

Hi vba_php. Thank you for the reply. I had tried removing the line:

Please Login or Register  to view this content.

I thought it might help. but it just had a different error. instead it highlighted the Line:

Please Login or Register  to view this content.

And said: Runtime errot "1004":

application defined or object defined error

So yeah, its been quite confusing.

I hope i haven't misunderstood.

Thank you for trying.

[vba_php]

well you tried to fix it. that's great! so exactly do you want to do? you said something about a variable and you attempted to use an array for something....

[Norie]

Try this.

Please Login or Register  to view this content.

[jolivanes]

Re: "But i realized that i need it to output data in other columns too so that each result would be under its appropriate column."
How would you determine these "other columns"?

Maybe show us your whole code because it looks like it might need some updating.

[Andy Pope]

It also looks from your code fragments that you are using the variable X before you assign a non zero value to it, which would give the 1004 error.

[vba_php]

It also looks from your code fragments that you are using the variable X before you assign a non zero value to it, which would give the 1004 error.

I was under the assumption knew what they were doing and/or had written code before. if I'm not mistaken, you can use any number var without assigning a val to it. a dec defaults it to 0.

[rorya]

That is true but Cells(22, 0) is going to cause an error as Andy said.

[vba_php]

That is true but Cells(22, 0) is going to cause an error as Andy said.

and why is that? is it because an unassigned val to a var that is not dec'd is inside a function? if so, I would like to know. that would be something to add to my KB. and if that is true, that's why i don't like office programs. PHP/javascript frameworks wouldn't do that. I know PHP doesn't.

[Andy Pope]

The column value needs to be a valid one, regardless of the variable type being used to store it.

The Msgbox's will error so comment out as you run and do your investigation.

Please Login or Register  to view this content.

[vba_php]

The column value needs to be a valid one, regardless of the variable type being used to store it.

isn't a default of 0 good enough? if 0 is there without a dec, and with a literal dec, what does it matter? must be a quirk of VBA?

[Andy Pope]

No the issue here is that ZERO is not a valid column reference.

It's not a quirk

[vba_php]

no kidding!? oh my goodness, I guess I never did check. I rarely use CELLS() or the .column property. thanks for pointing that out andy.

[FanAnd22]

Thank you guys. It all works!

Please Login or Register  to view this content.

The suggestion to use:

Please Login or Register  to view this content.

As well as to move the "Set destination" line after the initial declarations,solved everything!

Thank you. Thank you.

Everything is working perfectly.