I currently have this code saving a Column Letter to a freefile on my pc...
What I need:
I need it now to save the Column letter to a specific sheet in the current workbook and
"SheetData" and specifically cell "A1"
' ENTER VARIABLE HERE FROM TEXT FILE
Dim RowNumber As Integer, FileNum As Integer
Dim InFile As String, Curline As String
InFile = "C:\Program Files\Enterprise\Defaults\Column_Wwg_Located_Worksheet.txt"
FileNum = FreeFile
Open InFile For Input As FileNum
Line Input #FileNum, Curline
mCwrange = Curline