• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. V

    How to code a Variable Range in VBA

    Thanks Hui, Yes, the data area is growing with each additional row of data. A variable called DataPts tells me how many days of data is to be charted. Here is what I came up with while I was waiting for someone to respond to my post: FirstRow = 8 Delta = LastRow - DataPts + 1 If...
  2. V

    How to code a Variable Range in VBA

    I'm new to VBA so I hope someone can help me with a Range question. - I'm using Excel 2003 - Every week I add several days/rows of data - I have a Chart that I want to update when I add new data - I would like to pass the number of data points to be charted to the Sub - I created a user...
Back
Top