Home > Forum Home > Automating Data Analysis Tasks > Run Macro IF Specific URL Changes > Store URL requested in a cell Share

Store URL requested in a cell

Excel Help for Store Url Requested In A Cell in Automating Data Analysis Tasks


Forum TopicLogin

Store Url Requested In A Cell

Rate this:
(3/5 from 1 vote)
ShockedThe easiest way would be to store the request URL in a cell somewhere and interrogate this in your macro.  A cell could contain the URL and a separate named cell a formula which returns 1 or 0 depending on whether to run the macro. e.g. =IF(A1="http://www.google.com", 1, 0).  The cell could be named "blrun" for example.

In the macro, you then add the conditional statement.

VBA Code:
If Range("blrun") = 1 Then
  'run the routine
Else
  Exit Sub
End If
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Store URL requested in a cell in the