• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • Last Modified:

A better way to make this equation?

Quick form question:

Assuming all the variables are defined correctly and If we have –

i = cCell.row
addr = cCell.Address

With wsBas

      .Range(addr).Offset(0,-25).Value = wsQot.Cells(i, “V”).Value


Is there a way to make the left hand side of the equation in the same form as the right hand side of the equation?  

In other words, using the offset and counting it all out is getting burdensome.  Is there a way to reference the columns instead of the offset?   Much easier I think.  

Example:

Could it be?...

With wsBas
      
      Cells(i, “AA”).Value = wsQot.Cells(i, “V”).Value

...or some other similar form?

thanks!
0
BostonBob
Asked:
BostonBob
1 Solution
 
nutschCommented:
You can indeed use

Cells(i, “AA”).Value = wsQot.Cells(i, “V”).Value

but since you're not starting with the ., you're not picking up the parent. YOu might need to if wsbas is not the activesheet.

wsbas.Cells(ccell.row, “AA”).Value = wsQot.Cells(i, “V”).Value

you can also use

wsbas.range("AA" & i).value
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now