-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
indirect vba
-
M
Lookup from an index that contains dynamic pages
I'm going to do my best to explain this issue. I have been searching for days for an appropriate answer. So, here goes. I have a workbook that is used for productivity tracking. There is a master worksheet (Master), and separate worksheets for each day of the year (mm-dd-yy). The productivity...- MrDeadMan
- Thread
- indirect vba indirect vlookup indirect() vlookup
- Replies: 1
- Forum: Excel Questions
-
W
Mapping this Excel Formula to VBA
I currently have 28 distribution tables on 28 different worksheets in the same workbook. Im trying to get the following formula into my VBA code on the 29th (summary) worksheet - either into one cell that i can then fill across over a variable amount of months, or entered into that variable...- winneker
- Thread
- indirect vba vba vlookup
- Replies: 1
- Forum: Excel Questions
-
E
Single Quotes in VBA
Hi, I have the following formula, which works when I type it into a cell in excel: =OFFSET(INDIRECT("'" & $AM6 & "'!$A$" & MATCH($A6,INDIRECT("'" & $AM6 & "'!$A:$A"),0)),31,1) However, when I try to put this in VBA, I keep getting errors...I believe it's because of the double quotes and single...- eoinymc
- Thread
- excel 2007 formula indirect vba single quotation vba
- Replies: 2
- Forum: Excel Questions
