Going to a cell reference

[Duckmorph]

Im trying to workout the cell refrence and then go to a cell a couple over and enter data

So far i have

x = Sheet4.Range("A1").formula

'which returns x as =Markets!F155

Now i have the problem, i want to use the row number (155) and go to column "Q" in "Markets" and enter some data but i cant seem to get there. I have been trying to get a split to work but with no success.

Any ideas?

 

[wigi]

Hello

Can you please upload your file somewhere? Then helpers can have a look at it, as it seems that outputting a line of code to the Immediate Window seems too difficult.

 

[Duckmorph]

Hey

Sorry for your troubles, i cant seem to get debug.print to do anything. Ive since change the coding to.....

Dim Prow, PResult As Integer

Prow = CInt(MatchBox.Text) + 4
PResult = Mid(Sheet4.Cells(Prow, 9).Formula, 11, 6)

Sheet24.Cells(PResult,17) = "Something"

And i can get there that way instead, not at subtle as your original coding but its working.

Cheers