0

I can change "numeric format" ( decimal looking) in the "workbook sub procedure". But while I am calling from another workbook to "change active sheet's cell" I can not manage it. 

If IsNumeric(ActiveWorkbook.ActiveSheet.Cells(9 + ii, 32 + Z).Value) Then
    ActiveWorkbook.ActiveSheet.Cells(9 + ii, 32 + Z).Select
    Selection.NumberFormat = "0.00"
End If
BigBen
  • 38,994
  • 6
  • 24
  • 37
iincitr
  • 5
  • 7
  • 6
    You will want to [avoid using select](https://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba) in your code – cybernetic.nomad Jul 05 '19 at 14:57
  • 3
    You can only call procedures stored in a standard module from another workbook - not subs stored in the module sheet associated with a worksheet or the workbook. Move your procedure into a standard module. Also you only need Activesheet.cells(9 + ii,32+z).numberformat = "0.00" - never use select – Harassed Dad Jul 05 '19 at 15:29
  • Thank you Haressed Dad. I got it and it works. – iincitr Jul 05 '19 at 19:56

0 Answers0