Thread: [Solved] Select all cells in a column , even when blank...
View Single Post
 
Old 05-29-2018, 07:56 PM
Logit Logit is offline Windows 10 Office 2007
Expert
  
Join Date: Jan 2017
Posts: 533
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default
Code:
Option Explicit

Sub selectallrows()
     Worksheets("Sheet1").Activate
     ActiveSheet.UsedRange.Select
End Sub
Reply With Quote