Thread: Inserting Environment Variables into Cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Helmut Weber[_2_] Helmut Weber[_2_] is offline
external usenet poster
  
Posts: 163
Default Inserting Environment Variables into Cells
Hi Tevibear,

like this:

Sub test()
' cells(row, column)
ActiveSheet.Cells(1, 1).Value = Environ("Username")
End Sub

--

Helmut Weber

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"
Reply With QuoteReply With Quote