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


"Larry C" wrote:

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

Change "Selection" to Changecell.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Larry C" wrote in message ...
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

Thanks, that did the trick


"Jim Cone" wrote in message
...

Change "Selection" to Changecell.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Larry C" wrote in message
...
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