Macro in Excel 2003 will not run

  • Thread starter Thread starter Larry C
  • Start date Start date
L

Larry C

Hello,

I have a frustrating issue. I have Excel 2003 installed on Vista Home. I
have set my macro security to low. When I try to run the following macro it
only changes the starting cell. It seems pretty straight forward. am just
trying to remove the hyperlink from a column of cells

Sub macro1()
Dim Changecell As Range
For Each Changecell In Range("c1:c910")
Selection.Hyperlinks.Delete
Next Changecell

End Sub

What am I missing?

Thanks for any help

Larry C
 
Maybe

For Each Changecell In Range("c1:c910")
Changecell.Hyperlinks.Delete
Next Changecell
 
Change "Selection" to Changecell.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


Hello,

I have a frustrating issue. I have Excel 2003 installed on Vista Home. I
have set my macro security to low. When I try to run the following macro it
only changes the starting cell. It seems pretty straight forward. am just
trying to remove the hyperlink from a column of cells

Sub macro1()
Dim Changecell As Range
For Each Changecell In Range("c1:c910")
Selection.Hyperlinks.Delete
Next Changecell

End Sub

What am I missing?

Thanks for any help

Larry C
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
VBA set thick borders around non empty cells in range 0
Macro for all Excel Workbooks to print to PDF 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Macro Related to Paste Values 2
Run two macros for two different sheets 11
run a macro in excel when moving data 0
Excel Run macro upon cell edit 0

Back
Top