Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel 2003 & VBA: VLookup question
Thank you PHV and ck1999. The second formula suggestion worked great. Mixing the R1C1 and regular cell references wasn't working. Thanks again!- davis07
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel 2003 & VBA: VLookup question
When I run the VBA program, it runs that line in the code and inserts what I have indicated as 'yields'... I don't know where it is getting the Q:Q. Yes, the look-up value IS in the othersheet (name changed for simplicity). I want it to insert...- davis07
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel 2003 & VBA: VLookup question
Hi, I am trying to get the following equation to work. I want the vlookup command to search columns A thru C, but the formula doesn't work as is. I've tried relative references too, but can't get it to work. ActiveCell.FormulaR1C1 = _...- davis07
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Printing all embedded PDFs in Excel
I am trying to create a macro command that would format an Excel document into one page, autowrapping all cells then print the worksheet and all embedded PDFs one-by-one. For printing the PDFs, I'm thinking something similar to the following code could work, but this has some bugs and I'm not...- davis07
- Thread
- Replies: 0
- Forum: Microsoft: Office
