View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default select all cells in an active sheet containg links to other (external) workbooks.

The question back is why do you need to select? You can do almost anything
desired without ever making selections.

--
Don Guillett
SalesAid Software

"al007" wrote in message
oups.com...
How can i make the code below select all cells in an active sheet
containg links to other (external) workbooks.

For Each cell In ActiveSheet.UsedRange
If Left(cell.Formula, 2) = "=[" Then 'then select
cells how to put selection code??



Thxs