I am looking for code to change "If Intersect(Target, Range("G2")) Is Nothing Then Exit Sub
" to if there is nothing, I want to have a default of Range("G2") = PL030. how can I change the code to default to this?
I don't want to exit "Sub"
Please Login or Register to view this content.
Hi, madhatter40,
the line of code you mention is only checking for the cell which was changed in that sheet. If itīs not G2 then the macro will stop. I doubt you want the macro to start on any cell change in that sheet running your macro:
If you want to put in the value as a standard without triggering the macro, change the code after the Else toPlease Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
Last edited by HaHoBe; 02-03-2013 at 11:46 AM. Reason: Addition for changing value of Range("G2")
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks