Thread: Columns("C:C").Value = Columns("D:D").Value not working after adding16th page
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank[_29_] Frank[_29_] is offline
external usenet poster
  
Posts: 21
Default Columns("C:C").Value = Columns("D:D").Value not working afteradding 16th page
To add to my post, if I use this code

Range(("C1"), Range("C1").End(xlDown)).Value = Range(("D1"),
Range("D1").End(xlDown)).Value

it works.

But I am still curious why it does not work on a column basis
Reply With QuoteReply With Quote