Sponsored White Papers, Webcasts, and Downloads
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 >>
