i = ActiveWorkbook.Sheets.Count
Does ActiveWorkbook.Sheets.Count return an integer or a pointer to an
object in which case i can't be of both type. Then how "for i ..."
should be ?
Thx
Pascal
On Jul 3, 4:20 am, Dave Bonallack wrote:
> Hi,
> I don't think you can say "For i = 1 to i" since i is
Hi,
Could you please tell me why this code is not working? From a
programming background, i see no reasons why the code is not giving
worksheets names through this for loop :
Option Explicit
Public Sub SheetList()
Dim W As Worksheet
Dim i As Integer
Range("A1").Select
For i =
