Hi

When writing a VBA procedure, somehow I can't refer to workbooks by their
name anymore.
P.e. in Watch window
Workbooks("ReadRep")
returns an error "Subscript out of range". At same time p.e.
Workbooks(1)
works.

So I have to use p.e.
Workbooks(1).Sheets("Raport").Range("B6:H" & [RowCount] +
5).ClearContents
instead of
Workbooks("ReadRep").Sheets("Raport").Range("B6:H" & [RowCount] +
5).ClearContents
, but I can never be sure, that there were no workbooks opened before.

Another odd thing: I needed in 2 columns to replace all commas with periods.
The code
ActiveWorkbook.Range("G:H")..Replace What:=",", Replacement:=".",
LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
did return an error. I tried
ActiveWorkbook.Range("G:H").Select
Selection.Replace What:=",", Replacement:=".", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
, and
ActiveWorkbook.Columns("G:H").Select
Selection.Replace What:=",", Replacement:=".", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

, and again did get an error - on Select command. The error message was
"Run-time error '438': Object doesn't support this property or method"


Has someone a clue, what is going on?
Thank in advance!

--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )