Hello everyone
First of all I don't solution by formulas at all as it is part of large code ..
I have two ranges which I need to store as VBA arrays : range("A1:N7") & range("A10:F14")
And each value in range("B10:F14") would be searched as described below and store the results in another array which will be put at the end in range("A18:F22")
I have attached two examples of the desired results
Hope it is clear
Thanks advanced for help
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Hi,
Here is an array formula that needs to be entered with CTRL/SHIFT/ENTER:
Enter it in cell B18, copy across and down.
Please Login or Register to view this content.
Hope this works for you and is helpful.
Cheers
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
@southward thanks a lot for help but in fact I mentioned at the first line of the thread as I don't need formulas (because simply I used similar one) but thanks a lot for sharing us the issue
Thank you very much Mr. AlphaFrog for this wonderful solution .. It is exactly as I needed ..
I will try to make this code in public procedure as I need to apply the same for multiple tables at the same time
Thanks a lot for help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks