Search results for query: *

I have all of these setting whenever I open Excel, not specific to a particular workbook... I don't have scroll lock on so that isn't affecting the keyboard shortcuts... The hidden columns appear when entering an = and then yes, they do re-hide when I press enter. The ' appears after pressing...

Hi, I don't know how, my I have managed to gain some new and annoying Excel settings...I will try to explain.. When I start typing a formula, any hidden columns/rows are un-hidden automatically (temporarily), meaning I have to re-adjust my cell selections? Also, When I hide columns, I am...

Spend Sales £245.00 1 £210.00 7 £189.00 12 £187.00 5 £184.00 2 £168.00 5 £156.00 6 £145.00 4 £145.00 4 £120.00 2 Chosen value of Marketing spend is £644 So…A user wants to spend £650…the first three rows total £644, which is within an acceptable range of the chosen spend….so what would the...

Apologies if the title is not appropiate... If I have two columns of data and wish to sum one column, as far as the criteria specified elsewhere is met in another column....for example....column of marketing spend in column A, number of sales in column B. A user specifies a marketing spend of...

I've made the change as you recommended but the code stops at ActiveChart.SetSourceData Source:=rngG, PlotBy:=xlColumns I've looked at the original code, and see no differences? iRw1 = 37 iRw2 = Sheets("cost to Connect by Creative").Range("b65536").End(xlUp).Row Set rng1 =...

Ok, thanks, but this doesn;t seem to be working...Where you have sheet1 would I be right in thinking I need to change to the name of the sheet where the data is held? If so, what is the correct syntax? I tried the sheet name enclosed in " but that also failed? The error code I get is 'Method...

Thanks Bong, but there is no option/point at which someone could enter a value..I was looking for a method of selecting a start point for the range (fixed) and then referncing as far as the last row that contains data (and could vary)...Which I think Skip was referring to, but I can't see where...

Thank you both for your help, but I am not sure what you are telling me to do...or where to insert the code? I understand that you are providing a variable range of some type, but what is a union method? Skip - How do I repeat the xampel you gave me? Do i repeat for each colum with a , between...

All three columns will always finish at the same row, and I would always want to go to the last populated cell in the range. Thanks.

Hi, Below is the code I recorded to draw a graph based on a fixed range of data that is not contiguous. I would like the graph to be drawn using the same start points for each series range, but with a varying number of rows. The data is always in these columns - B,D, F and I and will always...

It's ok, have fixed it now. thanks anyhow.

Hi, I am trying to write a piece of code that sums three cells, and then if the value of the sum is zero, delete the entire row...there will be a variable number of rows within the data, and any positive values need to be left. I tried the below code, but it doesn't achieve my objective...any...

Hi, I am trying to do something very similar and am little stuck, I have tried to replicate the above code but it doesn't seem to delete the required data...see code below: Range("O7").Select ActiveCell.FormulaR1C1 = "=RC[-2]+RC[-3]" Range("O6").Select ActiveCell.FormulaR1C1 = "REF...

I can record a 'normal' graph...that's reltively easy, but I want to set it for a variable range rather than a fixed range...Also, the data is not contiguous and I would like one bar and one line rather than two of the same...thanks.

Hi, Is anyone able to point me towards a tutorial that can teach me how to draw variable range dual axis graphs in vba? I have read through a few, but still not getting the structure/meaning of the code in the examples. Thank you

Hi, new to Excel vba and struggling with a copy paste function...I have a list of values, in column A, which has a variable range but a fixed start point...so could be a2:a30 or a2:a22....I then have a line of formulae in b2:h2 which I would like to copy and paste for the number of rows that is...