Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Gin Tanaka   on Aug 29 In MS Office Category.

error "object does not support this property or syntax"


  
Question Answered By: Rolando Reed   on Aug 29

Try this more effecient code next time

sheets(1).cells(i, 8).copy
sheets(1).cells(i, 8).paste

That is all that is needed. Note sheets(1) will point to worksheet 1 regardless
of the name.

Share: 

 

This Question has 4 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on error "object does not support this property or syntax" Or get search suggestion and latest updates.


Tagged: