Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

A better way to make this equation?

Posted on 2014-03-25
Medium Priority
257 Views
Quick form question:

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

i = cCell.row

With wsBas

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
Question by:BostonBob
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
1 Comment

LVL 39

Accepted Solution

nutsch earned 2000 total points
ID: 39954647
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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Suggested Courses
Course of the Month9 days, 13 hours left to enroll