i need to link a cell to another cell in a document, it would take ages to do by hand so i wrtoe some formulae!
unfortunately this produces "application-defined or object defined error"
Please Login or Register to view this content.
now when i run it without the = sign as just paste as text not formulae i get a nice looking string of something like:
M:\Television and Broadband\DATA_2\[Austria_cable.xls]'!be$47
which looks about right to me
what s wrong with my code?
thanks
Jonathan
You've used the FormulaR1C1 property and then passed an A1 format formula.
Incidentally, what is column "**" supposed to be? (there appears to be a gap in your column sequence - is that correct? If not, then your code can be simplified a lot by just using a-4 as the column, instead of clet.)
Remember what the dormouse said
Feed your head
Hi,
there was not supposed to be a gap in the column but is didn't know how else to do it
also how would i go about passing an A1 formula to a cell?
thanks
Jonathan
You would use the Formula property, not the FormulaR1C1 property, but here it's easier to adjust the formula you pass into R1C1 notation:
Please Login or Register to view this content.
hey thanks,
that looks much more concise then my code
but i still get the error on the line
Cells(r, a - 4).FormulaR1C1 = "='M:\Television and Broadband\DATA_2\[" & country & "_cable.xls]" & cvalue & "'!R47C" & a - 4
What are the c, cothers and total variables supposed to be? They don't appear to have values assigned - are they public?
oooops
yeah they are part of a filename
i should have "" around them!
saying that.. when i correct this i still get the same error!
Are you sure the formula string is correct - i.e. workbook and sheet names both definitely tie up? Also, I assume the sheet you are trying to add the formula to is not protected and that the source workbook is also not password protected?
hi,
yeah i tried using a formula that i know to work instead of the generated one and that refuses to play ball as well
Well, those are the only things I can think of, and I can't verify them - you'll have to do that. What you could do is enter a working formula manually, then with that cell selected, enter:
in the Immediate Window in the VBEditor and compare that to the string being produced by your code.Please Login or Register to view this content.
hmm why i try that i get a "method not valid without suitable object" error!
What did you have selected at the time, and where did you enter the code?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks