Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel vba help plz
i wont to make an if statment in vba for excel that will if y circumstances are met will minus x from a specific cell once only -- chavicide ------------------------------------------------------------------------ chavicide's Profile: http://www.excelforum.com/member.php...o&userid=33798 View this thread: http://www.excelforum.com/showthread...hreadid=535672 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel vba help plz
bump bump bump bump -- chavicide ------------------------------------------------------------------------ chavicide's Profile: http://www.excelforum.com/member.php...o&userid=33798 View this thread: http://www.excelforum.com/showthread...hreadid=535672 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel vba help plz
Hi there,
Not sure what you're talking about here, but maybe something like this ... Public blnRan as boolean Sub Testing() Dim rngCalc as range Set rngCalc = Workbooks("Book1.xls").Sheets("Sheet1").Range("A1" ).Value If y = "met" Then If blnRan = False Then rngCalc = rngCalc.Value - x blnRan = True End If End If End Sub HTH -- Regards, Zack Barresse, aka firefytr "chavicide" wrote in message ... i wont to make an if statment in vba for excel that will if y circumstances are met will minus x from a specific cell once only -- chavicide ------------------------------------------------------------------------ chavicide's Profile: http://www.excelforum.com/member.php...o&userid=33798 View this thread: http://www.excelforum.com/showthread...hreadid=535672 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |