Returning a value, not a formula - Xtreme Visual Basic Talk

04-11-2006, 12:21 PM

zx12r

Newcomer

Join Date: Mar 2006

Posts: 5

Returning a value, not a formula

Hey all, I need a little help with something pretty basic. I have a macro that performs a simple calculation. How do I return only the result, the integer information, to the cell without the formula tracking along with it?

ActiveCell.FormulaR1C1 = "=R[-1]C+1"

Thanks for any help on this!

04-11-2006, 12:25 PM

zx12r

Newcomer

Join Date: Mar 2006

Posts: 5

I've been trying something like this...

Dim z As Integer

Set z = ActiveCell.FormulaR1C1 = "=R[-1]C+1"
ActiveCell.Value = z

But calling out a formula in a variable definition seems to be a problem...

Thanks again....

04-11-2006, 01:02 PM

rick_deacha

Sith Lord

Retired Leader
* Expert *

Join Date: Feb 2004

Location: Monterrey, Mexico

Posts: 2,179

Code:

Dim z As Integer

z = Activecell.offset(-1,0).value + 1
ActiveCell.Value = z

Should do the trick, or just

Code:

ActiveCell.Value = Activecell.offset(-1,0).value + 1

__________________
Rick
Use [vb][/vb] | Refer to VBA or VB | Newbie? run the Macro Recorder
Excel and VB Automation :|: Excel FAQ

04-11-2006, 02:22 PM

zx12r

Newcomer

Join Date: Mar 2006

Posts: 5

Perfect! Thanks!

Posting Rules

You may not post new threads

You may not post replies

You may not post attachments

You may not edit your posts

BB code is On

Smilies are On

[IMG] code is Off

HTML code is Off

Forum Rules