Search results for query: *

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...

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...

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...

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, 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...