worked inVBA-Excel95/but not 97 
Author Message
 worked inVBA-Excel95/but not 97

Wrote this is Excel7.0-VBA....Runs fine in Excel/95!  Under Excel/Off97
the 'offset' command either does NOT work or renames all over the place,
rather than next row down.     Here's code.....what's diff. in VBA lang.
for Excel for 97?

        With Sheets("Database").Range("DBTop")
                'put some stuff in columns
                .Offset(1,0).Name= "DBTop"
        End With

Thanx for help



Mon, 14 Feb 2000 03:00:00 GMT  
 worked inVBA-Excel95/but not 97

Try

        With Sheets("Database").Range("DBTop")
                'put some stuff in columns
                .Offset(1,0).Select
       End With
        Application.Names.Add Name:="DBTop", RefersTo:=Selection

Quote:

> Wrote this is Excel7.0-VBA....Runs fine in Excel/95!  Under
> Excel/Off97
> the 'offset' command either does NOT work or renames all over the
> place,
> rather than next row down.     Here's code.....what's diff. in VBA
> lang.
> for Excel for 97?

>         With Sheets("Database").Range("DBTop")
>                 'put some stuff in columns
>                 .Offset(1,0).Name= "DBTop"
>         End With

> Thanx for help




Tue, 15 Feb 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. DLL usage - works in Access 97 but not in Access 2000

2. VB expressions do not work properly in different installations of Access 97

3. Parameterized Update query not working correctly in Access 97

4. Access 97 - Application.Quit does not work if msgbox is displayed

5. Access 97 RecordsetClone not working for Date

6. DeleteObject not working with Access 97

7. Why does this piece of code work with Word 97 but not Word 2000

8. Reference from Off.97 to Off.XP did not work after converting

9. Selection.InsertRowsBelow does not work in Word 97

10. Correlated subquery in DELETE stmt not work in Access '97 or 2000

11. ADO OLEDB will not work on Access 97

12. Visdata Grid not working with Access 97

 

 
Powered by phpBB® Forum Software