Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
selection in VBA
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
selection in VBA
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
selection in VBA
Hi Dave, thanks for the help. I just came up with this: Dim r As Integer Dim c As Integer r = Range("BJ3").Value c = Range("BJ4").Value Range("C4").Select Range(Selection, ActiveCell.Offset(r - 1, c - 1)).Select but I think I will go with what you gave me...thanks again! Regards 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add "left align across selection" cell formatting | Excel Worksheet Functions | |||
Insert Picture from dropdown selection | New Users to Excel | |||
Selection mode problem | New Users to Excel | |||
Max Value in a column exclude selection - Excel VBA | Excel Discussion (Misc queries) | |||
Cell Selection after "Enter" | Excel Discussion (Misc queries) |