The macro below enters date/time in col A and then selects col B ready for
me to enter the result of a broadband speed test. The macro has been asigned
to a button on the sheet.
The URL for the broadband test is
http://www.broadbandwatchdog.co.uk/speed-test.php
If the button is hyperlinked to the URL the broadband test is run but the
macro is not.
Can you show me how to incorporate the URL in the macro so both bradband
test is run and the date time entered?
Thank you
Francis Hookham
PS - do tidy the macro - I am sure mine is a bit crude!
Sub Macro1()
Application.ScreenUpdating = False
x = Cells(Rows.Count, 1).End(xlUp).Row + 1
Cells(x, 1).FormulaR1C1 = "=NOW()"
Cells(x, 1).Copy
Cells(x, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Cells(x, 2).Select
End Sub