I'm trying to autofill a range with the following formula:
But the wildcard is giving me trouble. How can I make this work?Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks for the help
I'm trying to autofill a range with the following formula:
But the wildcard is giving me trouble. How can I make this work?Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks for the help
Maybe like this?
Please Login or Register to view this content.
I get an "Object variable or With block variable not set" error.
This is the code I tried:
Please Login or Register to view this content.
I have attached a simple workbook if that helps
Last edited by perducci; 10-01-2012 at 02:40 PM. Reason: added workbook
Hi perducci
At a minimum I'd think you need to add this linePlease Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
I still seem to get an error
I still need help with this one! Is there a solution????
See the excel attachment for an example
Hi perducci
Try this...it seems to work for me.Please Login or Register to view this content.
That looks great, thank you thank you thank you!!!!
Hi perducci
You're welcome...glad I could help. Thanks for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks