Reading frrom a protected Range in Excel

[duke_man]

I have an Excel template that uses VBA code to process data from several
other Excel workbooks.

The embedded VBA code reads data from these other workbooks. For example:

For j = 3 To 14
Set myrange = wb.Worksheets(iETCsht).Range(Cells(11, j), Cells(27, j))
B(j) = Application.WorksheetFunction.Sum(myrange)
Next j

The problem I'm having is sometimes the cells I'm reading from have spaces
instead of numeric data or blanks. When this is the case, the macro displays
either an "Error 400" or "Application defined Error 1004" depending on how
I've configured VBA for error handling. Often these workbooks have password
protected cells so i cant simply fix the offending cells.

I've tried using "On Error Resume Next" to get around this situation but I
still get the errors.

Any thoughts on how I can make my macro code more robust?

 

[Cindy M.]

The problem I'm having is sometimes the cells I'm reading from have spaces

instead of numeric data or blanks. When this is the case, the macro displays
either an "Error 400" or "Application defined Error 1004" depending on how
I've configured VBA for error handling. Often these workbooks have password
protected cells so i cant simply fix the offending cells.

Since you haven't gotten a reply here, try asking in the excel.programming
newsgroup.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[duke_man]

I'll try that. Thanks, Cindy.

Since you haven't gotten a reply here, try asking in the excel.programming
newsgroup.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)


This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail