pasting this formula

Hi All,

I have this formula:

=Roundup((C10 * constants!$F$4),0)    ...and to paste this into VBA I have....
= "=Roundup((C" & i & "*" Constants!$F$4 & i & "),0)"

So if I have this formula:
=VBAround(Tickets!V10,,Round!B$1)   ....how would I paste this into vba...?



thanks!
BostonBobAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
MacroShadowConnect With a Mentor Commented:
"=VBAround(Tickets!V10,,Round!B$1)"
"=VBAround(Tickets!V" & i & ",,Round!B$1)"
0
 
BostonBobAuthor Commented:
One quick follow up:

What would this look like if "Tickets" was instead "Red Line"?

"=VBAround(Tickets!V" & i & ",,Round!B$1)"

Would that be?....

"=VBAround(Red Line!V" & i & ",,Round!B$1)"
0
All Courses

From novice to tech pro — start learning today.