help macro

How to I increment the x and y data sets by one? ------------------- Sub main_ols() Dim x, y, z, Dim strMsg As String For x = 2 To 500 x = RangeToArray(Sheet4.Range("B2:B51")) y = RangeToArray(Sheet4.Range("C2:C51")) z = regress_orthols(x, y)...

Hello! I need to create a macro that updates some datas for me, but I am having some troubles switching workbooks. I need to activate a workbook that has the date of the yesterday on it's name. i.e: a have an workbook that is updated everyday, so it's name is Open PO_yyyymmdd. This macro...

Hello, I have a longer code, but I'll save space. Essentially I have a "For Each rCell in Range..." code and I want to use that moving rCell as a reference to create another variable (sCell) that is used just for that one rCell, then on to the next rCell. For Each rCell In Range(Range1a...

With help from Wigi, I have a nice little chunk of code that does some work for me. It utilizes two workbooks. One is like the master file, the second is a data file with 15 sheets or so. I am trying to keep from copying and pasting by allowing the code to pick up the sheet name (which is...

I'm a new user of macros I have recorded a macro were it measures correlation between the cells. My problem is that I have to do that procedure for a lot combinations that's why I record the macro My cells range that is recorded starts from the cells JSL6-JU6. I want to make the same procedure...

Hi, I am trying to update an old macro and only have a basic knowledge of VBA. Each month we receive input files from multiple sources. Each file has data on a "Current Fcst" tab. Dates are in column C and Data resides in various columns moving out. The format is always the same, new dates...