Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Many thanks indeed for your assistance and quick response. The code worked
very well and I have now added code to read each sheet in the workbook and compile a very useful summary report of the whole wkbk. "Dave Peterson" wrote: See one reply at your post in .setup. sgl wrote: Hi All! I have several sheets in a wkbk where the user enters data in fixed cell addresses. Cells are non contiguous. I want to read the values from each sheet and cell and compile a tabulated summary report on a "Report" sheet in the same wkbk. Each sheet results to be on a separate row. Using office 2000 Thanks in advance for any assistance sgl -- sgl -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
Read write non contiguous cells | Setting up and Configuration of Excel | |||
Altering read/write facility of individual cells | Excel Discussion (Misc queries) | |||
Programatically read & write excel cells | Excel Programming |