Hi There -
I am trying to take convert my variable LC1 into a letter. Please see code below. I need to replace the hardcoded "C" with the equilvalent letter of LC1. Thanks!
Dim LR1 As Long
Dim LC1 As Long
LR1 = Range("A:AO").Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
LC1 = Range("A:AO").Find("*", SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column
Range("A2:C" & LR1).Select
Selection.Copy
I am trying to take convert my variable LC1 into a letter. Please see code below. I need to replace the hardcoded "C" with the equilvalent letter of LC1. Thanks!
Dim LR1 As Long
Dim LC1 As Long
LR1 = Range("A:AO").Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
LC1 = Range("A:AO").Find("*", SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column
Range("A2:C" & LR1).Select
Selection.Copy