Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • 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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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