Hi
I tried to amend the following macro however before I can proceed any further its giving me an error
The first line of formula works ok
The second and third lines of formula is where the problem lies
will appreciate all help in order to fix my macro wherever possible
Thank you in anticipatioe
Please Login or Register to view this content.
Last edited by khanaran; 01-28-2020 at 03:55 AM. Reason: fix spelling
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however the thread title does not really convey what your request is about.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
Hi Sir
I tried to correct title will this be ok
Raj
Not really. You talk about an error. Where does it appear in your code ? Which error is it?
That would be a good start for a decent title
Hi Sir
will this change on the title be better
Raj
Which error do you get???
In your description you talk about 1st line of code, second, etc... Those are only declarations.
Hi Sir
This formula in the code is giving me the error
regardsPlease Login or Register to view this content.
You need to double-up on the quotes inside the formula, in the same way you have with the formula for column K
Hi Sir
can you please show me where to double up on the quotes please
regards
raj
Any quote (") that is INSIDE the formula must be doubled (""). Besides that you have a bracket problem too. Best is to build the formula in a cell, then make all quote signs double.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Hi
When I do it manually it works but when am trying it in the macro its giving me an error
am not good at macros got help mostly with this
Ok but when i try your formula in a cell, it gives an error because of the brackets, so can you post exactly manual formula from cell? Then I'll add the quotes.
H
Thanx
this is the formula that I use in the cellPlease Login or Register to view this content.
Thank you so much
Raj
Becomes:Please Login or Register to view this content.
And:Please Login or Register to view this content.
Becomes:Please Login or Register to view this content.
As you can see all I did was take the quotes inside the formula, and put 2 quotes in all places that had 1Please Login or Register to view this content.
Hi Thanx for fixing the formula
however when I add the range with the formula, it creates the column "O" but
the values are not written in
regardsPlease Login or Register to view this content.
raj
Those O's in the range actually look like a number 0 not letter O?
Also, before the .Value = .Value line.... is the result of the formula ok? It may be the formula itself is not working as you wish
Last edited by Arkadi; 01-28-2020 at 12:52 PM.
Hi Thanx
I am attaching a manual sheet that has the formula that works but when I try to put into macro
it creates the column but does not write in the values
regards
What exactly are you expecting to see in column O?
In column N we have the following values (10-50-2) and the formula in col O will return the avg of RH +MD of column N i.e. (10+50)/2 = 30
manually it works but when I try macro it creates col O but no values is entered therein
regards
raj
because you are inserting columns your columns are not in the right place
Hi
Thanx for pointing out my mistake
can you please guide me as to how I can get the macro to what I would like it to do
Raj
Not without knowing what you are trying to do.
Hi
Ok thanx
I will add in here the macro and also a file to show what I would like to achieve
the worksheet racescrape is where I paste in data after it had been scraped and run the macro
racedata is the file that's is created the first formula is ok but the second and third , columns created but the formula is not written
regards
raj
TryPlease Login or Register to view this content.
Hi
Many thanx for the fix, its working brilliantly
only small snag its showing last entry of one race to the beginning of the second race a #value error
kind regards
Raj
Then change thisto whatever it needs to be.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks