Hello,
I have several spreadsheets in a workbook with colums A to K
Column 'A' DOES NOT have info in every line

How would I select only the lines in column A that DO have info in
them so that I can paste a link to another spreadsheet in the workbook

Thank you for any help
--
Martin
©¿©¬

Hi Martin,

Am Fri, 23 Sep 2016 17:20:23 +0100 schrieb Martin ©¿©¬:

Hello,
I have several spreadsheets in a workbook with colums A to K
Column 'A' DOES NOT have info in every line

How would I select only the lines in column A that DO have info in
them so that I can paste a link to another spreadsheet in the workbook

Select column A = Find & Select = Go to Special = Constants

or with VBA:

Dim rngC As Range

With Sheets("Sheet1")
For Each rngC In .Range("A:A").SpecialCells(xlCellTypeConstants)
'Your code


Regards
Claus B.
--
Windows10
Office 2016