Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Addition string from input box in to a formula (eg;R1C1 Formula)
=I have a file name in the input box which will be entered by the user.
=How can we call this variable into a formula. =for eg: I want to use the file name into a vlook up formula for getting some information from a different workbook. However, the formula for Vlookup is got by using Activecell.formular1c1 which allows us to get the formula by inputting the whole fomula with in codes. Hence, when I call for the variable file name in the middle of this formula its not recognising. Need help at the earliest. Rgds, Dev, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Addition to Formula | Excel Discussion (Misc queries) | |||
Addition Formula | Excel Discussion (Misc queries) | |||
Formula for addition | Excel Worksheet Functions | |||
R1C1 formula question | Excel Worksheet Functions | |||
R1C1 Formula in Excel | Excel Worksheet Functions |