Re: Check if a cell in a worksheet contains a link



On Jul 29, 1:40 am, Tuhin <minhazahme...@xxxxxxxxx> wrote:
Hello,

I am trying to write a macro in Excel using VBA. It will check if the
value in a cell has a hyperlink. If a hyperlink exist then copy the
value of that cell in the clip board, activate the hyperlink to go to
the linked worksheet, search for that value, if found get the cell
number, move back to the 1st worksheet and then update that link with
that cell number.

I tried "HasLinks" method but it doesn't work.

Any help will be appreciated.

Thanks

Tuhin

Since this is a Excel VBA question, I'd respectfully suggest you'd get
more response in the microsoft.public.excel.programming. There are
some here who can answer, but there are a number of real Excel VBA
gurus over there.

Tom Lavedas
***********
.



Relevant Pages

  • Re: Getting around Dependency Tree Performance Problems
    ... Bug in Excel VBA that causes the VBE title bar to be refreshed each time ... unless the calculation is initated from VBA: ... VBA UDFs are called by Excel even when their arguments are uncalculated. ... Using these techniques will reduce the worst-case timing for the 14000 cell ...
    (microsoft.public.excel.programming)
  • RE: Creating a ratings spreadsheet?
    ... It is easy to see a dabase entered into excel ... be implimented using Worksheet Change function. ... particular game in each cell will be counted in a separate cell or screen ... Other options can be found in the VBA menue Debug, ...
    (microsoft.public.excel.programming)
  • Re: If-formula without false part / put in cell operations / time limited spreadsheet
    ... If you want security, don't use Excel. ... > already made calculations must remain at all times. ... VBA is out of the question ... a content in cell C3: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: If-formula without false part / put in cell operations / time limited spreadsheet
    ... not possible without VBA. ... > I want to distribute a time-limited (locked with standard Excel ... > already made calculations must remain at all times. ... a content in cell C3: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: This is A LOT harder than I thought it would be
    ... No need for VBA. ... relative cell addresses ($x is an absolute row/column address; ... Excel, PowerPoint, and VBA add-ins, tutorials ... >> If Not TypeOf Selection Is Range Then Exit Sub ...
    (microsoft.public.excel.misc)