Type: Posts; User: Cees; Keyword(s):
Attached jpg of a vb that HansV wrote a little time ago - XferRatings.
Is it possible to change the value of Range("BF"...... by UserInput to any Range as required. e.g "BG", "CA" . etc ?
By Crikey - Hans, that was a quick and very helpful reply.
This old bloke -"haringkop uit Vlaardingen" - would have no chance of working that out.
On ye mate!
Hans, thanks for the macro. the IFERROR is now I(ISERROR.... etc.).
Still I have a few more question:
Cells U21:U24 and U26:U29 give me new ratings for teams A and B. These values are...
Thanks Hans. I went out and bought a John Walkenbach's book - "Favorite Excel 2007 Tips @ Tricks" and as you explained the iferror is new to 2007!
You are right I can get the values from line 1,...
Sorry about the 2007.
I have saved it as a 2003 file. Hope this helps.
So much for me tinkering (and learning) with Excel.
Attached a copy of the workbook.
I am trying to get the data from lines 1, 2, 3, etc in the "input data table and match records" automatically to be calculated in the "output data -...
Can I put a sample within the 100k?
I am stuck with a handicapping program. I am not an Excel expert just an old bloke tinkering away!
As per attached - I am trying to get Excel to read the data from lines 1,2,3,4 etc. into the...
A toast to you <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> <img src=/S/cheers.gif...
HUGE screenshot moved to zipped attachment by HansV - don't post images larger than 640 x 480 pixels, PLEASE!
First of all thanks for your help. This is to help with coaching. there is no...
Edited by HansV to provide link to post - see <!help=19>Help 19<!/help>
In my last post, <post#=545044>post 545044</post#> I showed the plot on the xy chart - it works fine and thanks to all for...
I took me a while - happens when you get older - must the Big Cheese's wine cellar <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> , but it appears I have been able to put a graph in...
As a coach, I am using thexy chart as a "polar plot" for the position of lawn bowls.
I can see the distance and angle from the Jack., whether the bowl has crossed the head (y-axis), are too short...
It is so obvious now. First reduce the size of the external perimeter and than resize the chart.
Thanks nad Merry Christmas. Any snow? and skating yet?
1. In my xy chart I get a lot of spare space around the chart which I like to eliminate and just have the chart area the same size as the chart without resizing. Is that possible?
2. Can I rotate...
I have seen his wine cellar and it was empty.................
You guys and girls drove him to drink it that way.
Ok, Ok, I helped him a little bit. <img src=/S/cheers.gif border=0 alt=cheers...
Thanks Leif. I'll have a go at that tomorrow.
We (the mrs and I) have 3 email accounts at home. Is it possible to have the emails received go directly to an inbox associated with that account?
If yes how do I go about it.?
In advance -...
My problem (outlook) started when my cousin from Holland (Alkmaar) visited for a week.
He left for Alice Springs this morning.
Good thing was that he brought Leidse...
I get this error:
"Cannot start Microsof Office Outlook. Unable to open the Outlook window. The set of folders coult not be opened. The server is not available. contact your administrator if...
Thanks fellows for your help.
All I now have to do is learning flash and incorporating it in my presentations. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> <img src=/S/read.gif...
This might not be the right forum, however....
I have made PowerPoint presention for coaching of lawnbowls.
PowerPoint is limited as it cannot do collinding bowls etc.
I have flash subroutines...
Today is the first time I am using PowerPoint to make a presentation on lawnbowls.
I can get the bowl to curve from the mat to its resting place.
Question is: Is it possible to show a "trail" of...
Thanks Hans. I'll give it go tomorrow, Saturday.
Right now it is time to turn of the computer (Mrs T will be happy)
and watch some of the Rugby Union World Cup.(Mrs T might not be so happy...