Advertisement
CleverSnake

VBA - trick to convert data to numbers

Oct 10th, 2020
1,923
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ' old trick to convert data to numbers
  2.    With Sheets("MD").Range("IV1")
  3.         .Value = 0
  4.         .Copy
  5.     End With
  6.     Sheets("MD").ListObjects("Masterdata").ListColumns("Код SKU "). _
  7.        DataBodyRange.PasteSpecial Operation:=xlPasteSpecialOperationAdd
  8.     Sheets("MD").Range("IV1").Clear
  9.  
  10. ' superior version
  11.    With Sheets("MD").ListObjects("Masterdata").ListColumns("Код SKU ").DataBodyRange
  12.         .Value = .Value
  13.     End With
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement