View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Hello Hello is offline
external usenet poster
 
Posts: 3
Default Error while moving sheet


"stevebriz" wrote in message
oups.com...

Hello wrote:
This is not the whole sub, and BP and EP do recalculate correctly
in Immediate window I see
? FName
Aug,01-Aug,15.xls

"stevebriz" wrote in message
ups.com...

Irek
where do you have BP and EP dim'd and there strings set?
i am thinking the BP and EP strings are not passing to this module

if you remove the ".xls" from Fname does it open ok?


Thx Steve
This is from the macro recorder:
Sheets("Jolanta").Move After:=Workbooks("Aug,01-Aug,15.xls").Sheets(1)

so .xls should be fine. Need to dig up dipper.
Irek