troubleshooting Question

Draw a value from another worksheet, not as static text but as a formula (using VBA)

Avatar of Andreas Hermle
Andreas HermleFlag for Germany asked on
VBAMicrosoft ExcelMicrosoft Office
2 Comments1 Solution85 ViewsLast Modified:
Dear Experts:

Below macro draws a value from another worksheet and enters it into Cell Z2 of the worksheet named "2_Results"

Worksheets("2_Results").Range("Z2").Value = Worksheets("3_OverallList").Range("Q2") & " have no company name!"

How do I have to tweak the code so that there is no static text in Z2 but the formula...

='3_OverallList'!Q2 & " have no company name"

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros