it doesnt seem possible for a text box to carry over formatting from what i can see, however you could put the formula in a cell behind the bar graph ...
The file attached appears not to be valid (zero bytes) Can you try again Purfleet
I think it was a combination of things, but merging cells is the devils own work It is always better to upload test data when asking questions or d...
Hi Sal Something like the below should work Sub FirstSmall() Dim rng As Range Dim firstVal As Integer Dim cell As Range Set rng = Range("a...
Assuming i have set up the data okay (its always better to attach example data so we can see what we are looking at) you have a couple of options here...
Strange worked for me on my laptop and desktop. Maybe it is because you have multiple Excel sessions open. Dont forget that what we are doing here ...
The simplest way would be to format the work sheet how you want it to look (porttrait/landscape/headers/footers/dates etc) as one time action, then cr...
Strange seems to work for me (well every other time) Try it with excel maximised to fill the whole screen
Like this? =$A$1&"."&ROWS($A$2:A2) Always best to add an example so we can see what we are up against Purfleet
That error is not the path, but the dodgy process we are doing for the screen dump. It works on the Visual Basic editor is open but not if closed! ...
Firstly i would like to say that Sunny's method is nicer if you can get it to work, however a macro can be useful if it has to do a lot of repetitive ...
Hi CY In my expirence ANYTHING is possible with a Macro as long as you are willing to find a work around. As Velouria has said its not really po...
As the data set is formatted as a proper table the macro will pick up any new data that you add you just need to right clikc in the piot table and ref...
Morning 1 - The file will be updated with approximately 50 inputs in column B in a day. All these values will be with unique numbers. The dump shou...
I agree with sunny for small, adhoc data sets filter is the easiest method but if it is repetitive and repeatable then a Macro can help. Attached i...