Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Roonaldez
  • Content: Threads
  • Order by date
  1. Roonaldez

    Strange Excel Settings

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

    Variable condition/range summing in Excel

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

    Variable Ranges with graphs

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

    Deleteing rows based on a cell value

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

    Graphs in VBA

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

    Cut and Paste to a Variable Range - Excel VBA

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

Part and Inventory Search

Back
Top