Send a command down a column

[mary]

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.

 

[carlo]

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

 

[Pete_UK]

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