Hi All,
I have a problem with a peice of code and I'm sure it's just the syntax that I'm getting wrong.
The following code is just a test to input a Vlookup formula to reference the cell next to itself. The adjacent cell will change which is why I can't just put in a static cell reference...
Please help!
Please Login or Register to view this content.
Remove the .Value from the left hand side of the equation. Excel is confused as the right side is a string.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
I've tried that but I get the same error (Application-defined or object-defined error)
Please Login or Register to view this content.
Last edited by JamesFletcher; 08-15-2013 at 05:39 AM.
I managed to fix it...I was clearly over-complicating things again!
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks