Thread: [Solved] Convert range format to number
View Single Post
 
Old 07-30-2018, 08:34 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
try:
Code:
With sht.Range("K2:N" & LR)
  .NumberFormat = "General"
  .Value = .Value
End With
You don't seem to have assigned anything to lastrow, but you have assigned something to LR.
Reply With Quote