with activesheet
with .range("C4").resize(.range("Bj4").value,.range("Bj 5").value)
.copy
.pastespecial paste:=xlpastevalues
end with
end with

pinmaster wrote:

Hi

Say I have 2 cells with values
BJ4 = 31
BJ5 = 3

how would I use those values in vba to select a range starting from a
specific cell (C4), in this case 31 rows tall by 3 columns wide then
copy and paste as values.

TIA

Jean-Guy

--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=515148

--

Dave Peterson