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)
|