Need Code edit - 3

VBABEGINER

Well-known Member
Joined
Jun 15, 2011
Messages
1,130
Hello All,
Getting error on this, can someone there to guide. Need correction..
Code:
Set sht = Application.Workbooks(Application.UserName & "." & "xlsx").Sheets(NewSh)
NewSh is Sheet Name. It is also Application.UserName
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

VBABEGINER

Well-known Member
Joined
Jun 15, 2011
Messages
1,130
I really thanks to MrExcel Board, B'coz of you atleast I can do something..which mean lot to me...(y)

On this query, any one have solution pls..:)
 

Watch MrExcel Video

Forum statistics

Threads
1,108,974
Messages
5,525,990
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top