Hi,
1. Could someone please check my macros [on my spreadsheet] and tell me why 'Altrincham' is coming through on each macro that is run?
Secondly, in module two, is it possible when running the Chart macro to have the range to cover offset 3 rows down from the figure in the table and covering 15 down and to J.
Assuming I will need
^
Please Login or Register to view this content.
Not sure how that coding works but I have seen it done.
ChartHelp.xlsm
Last edited by aaaaaaiden; 02-11-2014 at 12:39 PM.
You need to have a header value in Cell B1 - say, "Town", which will solve the Altrincham problem. Also, you should re-use your code instead of having it written out every time: see below.
And I've added code to add the chart automatically.
Please Login or Register to view this content.
Last edited by Bernie Deitrick; 02-11-2014 at 01:47 PM. Reason: added explanation and code
Bernie,
Please use code tags with your code as per forum's rule.
That's great!
What could I do to have the Macro run when the B1 value changes?
Sorry - I'm new and haven't totally figured this forum out yet...
If you are changing the B1 value to the various regions (NE, SW, etc.) use data validation on cell B1 (with the list option, and the various region names) and copy this code, right-click the sheet tab, select "View Code" and paste the code into the window that appears. You can then delete all the Sub NW(), Sub LondonRegion(), etc. since this will handle all that.
Please Login or Register to view this content.
Bernie,
You can add code tags in the following way.
Highlight the entire code, on the quick reply menu(Above this space), you see the pound sign, i.e. #, just click it.
If you have already post the code with out tags, you can edit you post, by clicking edit , then select the code and click the # sign.
Thanks - I figured that out
you could use below code as all in one and give a dropdown list of all regions in B1 of comparison sheet
Please Login or Register to view this content.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Perfect got it to work.. thank you all +rep'd
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks