home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.lang.visual.basic      MS Visual Basic discussions, NOT dot-net      10,840 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 9,213 of 10,840   
   Steve Gerrard to Punky   
   Re: Accessing newly created worksheet in   
   12 Feb 05 09:34:44   
   
   From: mynamehere@comcast.net   
      
   "Punky"  wrote in message   
   news:420e3241$0$13747$cd19a363@news.wanadoo.nl...   
      
   | In the above code the lines Range ("A1").Text = "Deelnemer" and the   
   one   
   | below won't do what I expect them to and the lines I use (and have   
   | successfully used last year) for writing data to cells give an error   
   424:   
   | object requiered (or similar, language is Dutch (object vereist)).   
   This is   
   | the code I use:   
   | If Range("M3").Text = sRace Then   
   |                ActiveCell.Offset(0, 12).Value = iPunten   
      
   In my Excel 97 help file, the Text property is listed as Read Only for   
   the range object.   
   I think using the Value property instead should work:   
      
       Range("A1").Value = "Deelnemer"   
      
   I'm not sure about the second one. However ActiveCell may not refer to   
   Range("M3"), if that is what you want. Maybe what you need is   
      
       Range("M3").Offset(0,12).Value = iPunten   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca