Can't put formula result into cell by Macro..

[ivek]

Ok ppl. I'm kinda new to VB and i really can't understand why this code doesn't work.

Should i be using some other functions?

Please Login or Register  to view this content.

If i remove that "=" in front of MID, cell gets the value but formula can't do it's job.

If i leave it, and i have to for formula to wok, i get error '1004'

Help

[Ron Coderre]

I think the problem is in your function argument separators. They should be commas not semicolons.

Try this:

Worksheets("Sheet1").Cells(2, 9).Value = "=MID(D" & row & ",1,((SEARCH("","",D" & row & ",1))-1))"

Does that help?
Ron

[ivek]

I think the problem is in your function argument separators. They should be commas not semicolons.

Try this:

Worksheets("Sheet1").Cells(2, 9).Value = "=MID(D" & row & ",1,((SEARCH("","",D" & row & ",1))-1))"

Does that help?
Ron

OMG, i'm stupid


Yes, that helps. Of all the things in the world...commas

Thanx