Thread: Nested if in VB
View Single Post
  #4 (permalink)  
Old October 6th, 2009, 12:34 AM
Wenggo Wenggo is offline
Authorized User
  
Join Date: Mar 2006
Posts: 58
Thanks: 0
Thanked 0 Times in 0 Posts
Default Copy range excluding cell format
Morning bro and sis,

I want to copy range excluding cell format I need only cell value, anybody ? I tried with code below but the result pasted with cells format.

Sheets("WK01").Select
Range("B36:B36").Select
Selection.Copy
Sheets("WK02").Select
Range("B5:B5").Select
ActiveSheet.Paste

Regards...
Reply With Quote