I have a workbook that has many sheets within it each worksheet has a cell H2 which is a different value on a number of sheets e.g. 26.245
There is an index sheet which gets populated with values from each of the sheets, everything works well except for filling data in one particular cell
The formule I am using is
Me.Cells(1, 8) = (Mid(wSheet.Range("H2").Value, 1, 2) + (wSheet.Range("H2").Value, 3, 3)*32)))
So the formula should be A+(B*32) where A = 26 , and B = 245
One of the other cells on the index sheet gets populated using Me.Cells(1, 7) = Mid(wSheet.Range("G6").Value, 1, 6), so i know that part works.
What am i doing wrong in the formula?
There is an index sheet which gets populated with values from each of the sheets, everything works well except for filling data in one particular cell
The formule I am using is
Me.Cells(1, 8) = (Mid(wSheet.Range("H2").Value, 1, 2) + (wSheet.Range("H2").Value, 3, 3)*32)))
So the formula should be A+(B*32) where A = 26 , and B = 245
One of the other cells on the index sheet gets populated using Me.Cells(1, 7) = Mid(wSheet.Range("G6").Value, 1, 6), so i know that part works.
What am i doing wrong in the formula?