View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default Using a Range variable to call a procedure with a ByValstatement...

The Workbook_Open event doesn't take any arguments. It is placed in
the ThisWorkbook module for a workbook and runs when that workbook is
opened. Where did you come up with that code?

--JP


On Sep 17, 2:23*pm, R Tanner wrote:
Hi,

I am trying to call a procedure and I can't figure out how to do it
correctly. *This is my call statement.

*WorkBook_Open
(filename:=Range("O2").Value,cutrange:=range("O5") .address)

The following is the procedure I am trying to call:

Private Sub WorkBook_Open(ByVal FileName As String, ByVal CutRange As
Range)