Thread: Nested if in VB
View Single Post
  #5 (permalink)  
Old October 9th, 2009, 04:27 AM
Wenggo Wenggo is offline
Authorized User
 
Join Date: Mar 2006
Posts: 58
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Wenggo View Post
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...
Anybody had any idea for this case ?
Reply With Quote