I regularly have report output of varying sizes that will have one column of
data (the column changes position too) that has hyperlinks. How can I record
a macro to remove the hyperlink for the entire row? I essentially want to
send the command down an unlimited number of rows.

the following sub should help:
----------------------------------------------------------------
sub ClearHL()

dim int_col as integer

int_col = 2 ' inputbox "Please put in the number of the column"

Columns(int_col).Hyperlinks.Delete

end sub
----------------------------------------------------------------

you can set int_col in various ways...just change it to what suits you
best.

hth

Carlo

On Dec 7, 10:31 am, mary wrote:
I regularly have report output of varying sizes that will have one column of
data (the column changes position too) that has hyperlinks. How can I record
a macro to remove the hyperlink for the entire row? I essentially want to
send the command down an unlimited number of rows.

One way is to highlight the column which contains the hyperlinks, by
clicking on the column letter.

Then ALT-F11 (will bring up the Visual Basic Editor)
CTRL-G (will open the Immediate Window)
then type the following:

selection.hyperlinks.delete (Enter)

Then close the VBE to return to the worksheet.

Hope this helps.

Pete


On Dec 7, 1:31 am, mary wrote:
I regularly have report output of varying sizes that will have one column of
data (the column changes position too) that has hyperlinks. How can I record
a macro to remove the hyperlink for the entire row? I essentially want to
send the command down an unlimited number of rows.