Collect deraqilos from 1 column & paste link
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 ©¿©¬ |
Collect deraqilos from 1 column & paste link
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 |
All times are GMT +1. The time now is 12:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com