Hey i log information for my weekly work football and am trying to automate more of my collection of data. I have a set of data that looks like this:
<tbody>
<tbody>
Date
Game No.
Win
Draw1
Draw2
Loss
Win Goals
Draw1 Goals
Draw2 Goals
Loss Goals
Win Scorer
Draw1 Scorer
Draw2...
Greetings,
I am receiving a compile error on this line:
h = worksheetfunction.Slope((Cells(yy,ww):Cells(2,ww)),(Cells(yy,xx):Cells(2,xx)))
the first colin in the Y's range is highlighted. What is the correct syntax here again?
Thanks!
Hi there,
I have a list of names in excel in the below format; however I need to re-arrange the cells to read "Colin Smith", (dropping the ,).
<tbody>
Smith, Colin
Is there a simple way of doing this please?
Many thanks
</tbody><colgroup><col></colgroup>
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.