hi guys im having trouble getting formulas to stick
i think it may be something to do with the web query
if any one would be kind enough to help id be greatful and send the link
kind regards
hi guys im having trouble getting formulas to stick
i think it may be something to do with the web query
if any one would be kind enough to help id be greatful and send the link
kind regards
found it was actually possible to attach here
thought it was a lot larger than is
on the summary tab you can see there are 5 of #value!
the range should be b1000 but for some reason it changes
thanks guys
I added a couple missing $ signs and reran your GET RESULT macro a few times, seems to not change the values in the Summary as far as I can see. Maybe that's all it was?
Last edited by JBeaucaire; 03-05-2009 at 03:54 PM. Reason: Removed book, use one further down.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
ive just ran it straight away jb and its still returning #value!
it keeps changing the range too form b1:b1000
currently its saying b1:b1394
Must be an Excel 2007 thing. It's not doing that on my machine.
did you change the formulas in summary?
Yes, I just added a couple of missing $ symbols.
E14:
=SUMPRODUCT(--(ISNUMBER(SEARCH('input sheet'!$E1,'head to head'!$B$1:$B$1000))),--(ISNUMBER(SEARCH('input sheet'!$E1,'head to head'!$H$1:$H$1000))))
E16:
=SUMPRODUCT(--(ISNUMBER(SEARCH('input sheet'!$G1,'head to head'!$D$1:$D$1000))),--(ISNUMBER(SEARCH('input sheet'!$G1,'head to head'!$H$1:$H$1000))))
how about e18 and e19?
im really stumped now because its just changing your formula from b1:b1000
and again this time its b1280
i cant understand why that would change
Last edited by excellentexcel; 03-05-2009 at 03:50 PM.
Me either.
There are no formulas in E18 or E19.
sorry jb
i did mean c18 and c19
i have this in c18
something is making that particular part change for no reason as you can see this time its returning 972 although it was set at 1000Please Login or Register to view this content.
Well, I know what DOES make a formula with absolute references change themselves, it's when you delete entire rows within an absolute range. The absolute range is actually staying absolute by adjusting downward in this scenario because the row has been removed permanently from the sheet.
Deleting a row (and everything shifting up) is not the same thing as clearing the contents of a row. So, look at what your macro is doing, is it deleting rows instead of clearing contents somewhere?
Last edited by JBeaucaire; 03-05-2009 at 04:34 PM.
i have to admit
im stumped
this is the get results code
dont know if this line affects it or not jb
Please Login or Register to view this content.
Please Login or Register to view this content.
bump bump bump
any help greatly appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks