Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to write to a cell in another sheet in the same workbook using
the following code: strRow = "A" + CStr(nTempRow) With Worksheets("Temp") strTemp = "A" + CStr(nRow) .Range(strRow).Value = strTemp strTemp = "B" + CStr(nTempRow) .Range(strRow).Value = 0 End With When the code gets to fourth row, it bums out (skips to last function in module). The worksheet("Temp") is physically located as the first worksheet in the workbook. I have also used its number ("Sheet10"), but the same thing happens. The above With is within another With (have also tried this using Worksheet("Temp").Range(strRow).Value = ... In the Temp worksheet, Column A is formatted as General, Row B as integer Thanks, John H W |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Allow only writing in a protected Sheet | Setting up and Configuration of Excel | |||
Writing formulas between sheet | Excel Discussion (Misc queries) | |||
Writing to protected sheet from ASP.NET | Excel Programming | |||
Writing to protected sheet from ASP.NET | Excel Programming | |||
writing to excel sheet | Excel Programming |