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
|