Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does variable set to cell value automatically becomre cell value?
I think I know the answer to this, but I want to be sure. I'm incrementing
a value that is in a cell location describe in part by a variable. The formula looks like: ws.Cells(iMoRow, "T").Value = _ ws.Cells(iMoRow, "T").Value + iOVComplCON So the value in the cell is incremented by the variable "iOVComplCON" amount. No problem. Is this the same thing? iWt = Cells(iMoRow, "T").Value iWT = Cells(iMoRow, "T").Value + iOVComplCON or do I have to have another line added to the two above: Cells(iMoRow, "T").Value = iWt I'm pretty sure that I have to have the added line, which means it's a little simpler not to have the variable iWt at all, isn't it? Is there a better/shorter way to do the same thing? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does variable set to cell value automatically becomre cell value?
Responses in quted text below: salgud;583629 Wrote: I think I know the answer to this, but I want to be sure. I'm incrementing a value that is in a cell location describe in part by a variable. The formula looks like: ws.Cells(iMoRow, "T").Value = _ ws.Cells(iMoRow, "T").Value + iOVComplCON So the value in the cell is incremented by the variable "iOVComplCON" amount. No problem. Is this the same thing? iWt = Cells(iMoRow, "T").Value iWT = Cells(iMoRow, "T").Value + iOVComplCON NO or do I have to have another line added to the two above: Cells(iMoRow, "T").Value = iWt *Yes* I'm pretty sure that I have to have the added line, which means it's a little simpler not to have the variable iWt at all, isn't it? *Yes* Is there a better/shorter way to do the same thing? Only if you're referring to that cell in a lot of places in the code it might be worth adding a line before any of those places (usually straight after the value of iMoRow is changed) like: Code: -------------------- Set myCell = Cells(iMoRow, "T") -------------------- then use: Code: -------------------- myCell.value = myCell.value + iOVComplCON -------------------- not a lot shorter unless you choose to use a shorter variable name like 'MC' instead of 'myCell' Thanks! -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: 558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=161549 Microsoft Office Help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does variable set to cell value automatically becomre cell value?
On Thu, 10 Dec 2009 23:43:59 +0000, p45cal wrote:
Responses in quted text below: salgud;583629 Wrote: I think I know the answer to this, but I want to be sure. I'm incrementing a value that is in a cell location describe in part by a variable. The formula looks like: ws.Cells(iMoRow, "T").Value = _ ws.Cells(iMoRow, "T").Value + iOVComplCON So the value in the cell is incremented by the variable "iOVComplCON" amount. No problem. Is this the same thing? iWt = Cells(iMoRow, "T").Value iWT = Cells(iMoRow, "T").Value + iOVComplCON NO or do I have to have another line added to the two above: Cells(iMoRow, "T").Value = iWt *Yes* I'm pretty sure that I have to have the added line, which means it's a little simpler not to have the variable iWt at all, isn't it? *Yes* Is there a better/shorter way to do the same thing? Only if you're referring to that cell in a lot of places in the code it might be worth adding a line before any of those places (usually straight after the value of iMoRow is changed) like: Code: -------------------- Set myCell = Cells(iMoRow, "T") -------------------- then use: Code: -------------------- myCell.value = myCell.value + iOVComplCON -------------------- not a lot shorter unless you choose to use a shorter variable name like 'MC' instead of 'myCell' Thanks! Thanks for clarifying that. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does variable set to cell value automatically becomre cell value?
salgud;584130 Wrote: On Thu, 10 Dec 2009 23:43:59 +0000, p45cal wrote: Responses in quted text below: salgud;583629 Wrote: I think I know the answer to this, but I want to be sure. I'm incrementing a value that is in a cell location describe in part by a variable. The formula looks like: ws.Cells(iMoRow, "T").Value = _ ws.Cells(iMoRow, "T").Value + iOVComplCON So the value in the cell is incremented by the variable "iOVComplCON" amount. No problem. Is this the same thing? iWt = Cells(iMoRow, "T").Value iWT = Cells(iMoRow, "T").Value + iOVComplCON NO or do I have to have another line added to the two above: Cells(iMoRow, "T").Value = iWt *Yes* I'm pretty sure that I have to have the added line, which means it's a little simpler not to have the variable iWt at all, isn't it? *Yes* Is there a better/shorter way to do the same thing? Only if you're referring to that cell in a lot of places in the code it might be worth adding a line before any of those places (usually straight after the value of iMoRow is changed) like: Code: -------------------- Set myCell = Cells(iMoRow, "T") -------------------- then use: Code: -------------------- myCell.value = myCell.value + iOVComplCON -------------------- not a lot shorter unless you choose to use a shorter variable name like 'MC' instead of 'myCell' Thanks! Thanks for clarifying that. I forgot to suggest: Code: -------------------- with ws.Cells(iMoRow, "T") ... ... .Value = .Value + iOVComplCON End with -------------------- -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: 558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=161549 Microsoft Office Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If cell is blank automatically enter today's date in the same cell | Excel Discussion (Misc queries) | |||
how to cut part of a text from one cell and automatically paste itonto another cell | Excel Discussion (Misc queries) | |||
Automatically change cell colors based on date in cell | Excel Discussion (Misc queries) | |||
If data added to Excel cell it automatically make's another cell equal zero | Excel Programming | |||
How to copy formatting when moving from cell to variable to another cell on another worksheet | Excel Programming |