View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nicolas Nicolas is offline
external usenet poster
 
Posts: 6
Default Variable Range in Macro not working.

Hi all,
I´m trying to select a range by using 2 integer variables and I get
the following Error msg
----------------------------------------------------
Run-time error '1004':

Application-defined or object-defined error
----------------------------------------------------

The sitax is as follows:

Range("A" & fila & ":" & "F" & ultimafila).Select

Should i type it in a different way ?
All suggestions welcome.
BR.
NICOLAS