Hi all, is there a method to select all Cells in Excel (3 ,10) to be a hyperlink ? for the full column ?
ie:
Dim myLink as Hyperlink
myLink = "C:\MyDriver\MyFolder"
.Worksheets(9).Cells(1) = "PRESS AND HOLD 'CTRL'"
.Worksheets(9).Cells(2, 1) = "AND PRESS 'F' KEY"
.Worksheets(9).Cells(3, 1) = "WHEN THE SEARCH BOX APPEARS"
.Worksheets(9).Cells(4, 1) = "TYPE YOUR SEARCH"
.Worksheets(9).Cells(1, 3) = "SL-NUMBER"
.Worksheets(9).Cells(1, 4) = "DEALER"
.Worksheets(9).Cells(1, 5) = "PO-NUMBER"
.Worksheets(9).Cells(1, 6) = "LIFT TYPE"
.Worksheets(9).Cells(1, 7) = "LIFT DETAILS"
.Worksheets(9).Cells(1, 8) = "STATUS"
.Worksheets(9).Cells(1, 9) = "DELIVERY DATE"
.Worksheets(9).Columns("J:J) = myLink
.Worksheets(9).Cells(3, 3).CopyFromRecordset rs
.Worksheets(9).Range("C3:K3").Borders(xlEdgeTop).L ineStyle = xlContinuous
.Worksheets(9).Cells.EntireColumn.AutoFit
.Worksheets(9).Cells.EntireColumn.HorizontalAlignm ent = xlLeft
.Worksheets(9).Columns("I:I").NumberFormat = "dd-mmm-yy"Also can I add text into a cell called SEARCH then click on it to search entire workbook ?
Kind Regards