On The Insider: The Insider's 8 of 08
1 Resources for

redvamsi@...

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

Formula not working always in excel suing VBA
Hi alli've used a formula something likeactivesheet.cells(row,col).formula = "='C:Documents and SettingsAdministratorDesktop[sdfsdf.xls]Sheet1'!$A$12"this line will be in a loop , iterating for a couple of rows.But what is happening is, the formula works fine for most of the cells,but for a couple of a cells, ....instead of the result, the formula itself...
Tags: redvamsi@..., Microsoft VBA, cell
Discussion threads 2007-10-04
  • << Previous
  • page 1 of 1
  • Next >>


Network Administration in Windows Server 2003
While the role of a Windows network administrator would never be considered easy, you can lighten your load by knowing the ins and outs of Microsoft's ...
Buy Now
Windows XP vs. Mac OS X
This presentation, entitled Standardizing on Windows XP Instead of MAC OS X, provides a pre-packaged option for defending Windows XP against MAC OS X. ...
Buy Now