Chit Chat
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
01 Aug 15
10:54
Joined:
Date Joined:
23 May 09
I need some simple code that will put the trigger -1 into cell Q2 if cell V5 is not blank.
I've searched the gruss forum but no joy and excel/vba code hurts my brain.
Any help please
I've searched the gruss forum but no joy and excel/vba code hurts my brain.
Any help please
Show More
It missed out the smaller than/greater than part of the formula that should be inserted between V5 and ""
Thanks for the reply mate but if you use a formula it disappears when gruss refreshes, that's why i need code.
cheers anyway
cheers anyway
If you ever need future advice, speak to Gary or Mark.
Their support is fantastic, and they always come back pronto.
Their support is fantastic, and they always come back pronto.
I don't know about Gruss, but if you open the vba editor and select ThisWorksheet the you can insert code that updates your sheet every time something happens. On the left drop down select Workbook, then either SheetChange or SheetCalculate. You can then insert a simple if statement with runs every time something on the sheet changes or recalculates.
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539