View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Environ("USERNAME")

Break the line up into to line to help find the problem. I think the active
cell is the issue. You may have a workbook that is opening on a chart page
and not a worksheet page which is giving you the problem, the cell is
protected, or you are trying to write to a merge cell and not using the first
cell or the merged group.

UserName = Environ("USERNAME")
ActiveCell.Value = UserName



"Heera" wrote:


Hi all,

I am in tension because this particular code is not working in my
project.

ActiveCell.Value = Environ("USERNAME")

When I compile my project the cursor highlights this code and the
reference book gets open automatically. Please suggest.

Regards
Heera Chavan