VBA error ouside type block

[jakobt]

Statement invalid outside of type block:

Sub last_row
dim last_row as integer
rangecopy as range

last_row = Range("B" & rows.count).end(xlup).row
rangecopy = range("A1:I" & last_row).select
debut.print rangecopy
end sub

 

[mikerickson]

You need "Dim " before "rangecopy as range"

Then you will get more errors.

To set the variable rangecopy, you would use this kind of syntax

last_row = Range("B" & rows.count).end(xlup).row
Set rangecopy = range("A1:I" & last_row)

Debug.Print can't print a mutli-cell range, so that line would have to be

debug.print rangecopy.Address

Unless you want something other than the address.