outlawdevil
Board Regular
- Joined
- Jun 30, 2009
- Messages
- 238
I must have done something wrong with my code I want to update file path's month but I couldn't get it to take my code. I got a compiling error Can someone take a look? Thanks.
Change C1 value based on C2 list. Hopefully if anyone could add a code to active this cell as link. Thanks.
Change C1 value based on C2 list. Hopefully if anyone could add a code to active this cell as link. Thanks.
VBA Code:
Sub changemonth()
Dim ws1 As Worksheet
Set ws1 = Sheets("sheet 1")
range("C1").Value="C:\Users\cooll\Desktop\Lease Agreement\ & Text("C2",text) &"\week1\"
End Sub