dn.offset

I have a strange behaviour occurring whilst trying to load a Listbox on a Userform. I have the following code which populates the Listbox with data dependant on the value of column E: Private Sub UserForm_Initialize()Dim Rng As Range, Dn As Range, c As Long, Ray() Set Rng = Range(Range("A2")...

hi I have a problem am trying to build a forecast for my company and am using a formulas to fix this issue. but it make the size of the sheet over 20 MB with the date that I used more the 5000 row so when i run the sheet it take time to open and calculate this formulas . as far as I knew The...

The code below runs fine. But I also want to use it to take the results (Dn.Offset(, 6).Value = R.Offset(, 5).Value) and multiplies R.Offset by the value in in the current row. Sub Find_Parent_Quantity() 'Find the Parent's Quantity and place it in Column K Dim Rng As Range, Dn As Range, n As...

Hi all, kindly require to modify the below code so that to still prepare the "SUM" if one or more below accounts are missing. e.g. if the row in col. "A" with account description "FIXED EXPENSES" & "SUNDRY EXPENSES are missing, the code should run and prepare the "SUM" with the rest of them...

Hi all, i would like to modify the below VBA code so that to work to any spreadsheet. However i pasted it as a patch in another VBA code and a message appears as follow: Compile error Dublicate declaration in current scope I write off the first 2 lines and it runs without appear the expected...

MickG, MrExcel MVP, Congratulations Hello, MickG, please if you could, I need slightly modification in the following macro, that produce the constant occurrence result as follow If data C:P row start with "1" constant occurrence result start in column R If data C:P row start with "X"...