I have ran into an issue when trying to set a variable to equal the value of a particular cell. The code I have written for it is shown below:
I am trying to use the ActiveCell.Offset command because the cell that I am want the value from isn't always L1225. (Depending on user input)>Dim BidLabTot As Variant BibLabTot = ThisWorkbook.Sheets("CODESHEET UNSORTED").Range(ActiveCell.Offset(6, 0)).Value
Thank you for the help.
Bookmarks