LinkBack URL
About LinkBacks
Hi,
I have a table of data, which will often change in length. I have defined the first row of and last row of data as:
firstrow
lastrow
Is there a way to select these two rows as well as everything in between?
Thanks
Hi,
I have a table of data, which will often change in length. I have defined the first row of and last row of data as:
firstrow
lastrow
Is there a way to select these two rows as well as everything in between?
Thanks
Last edited by uncleslinky; 06-30-2011 at 05:14 AM.
Why do you need to select them? Typically there is a vba command that can reference those cells easily then execute the property adjustments you'd like.
I need to paste special values, however I do not want to select the entire worksheet. I only want to paste special values within that range.
If those two are actually named ranges:
or if you are pasting from elsewhere:
With Range("firstrow", "lastrow") .Value = .Value End With
Range("firstrow", "lastrow").PasteSpecial xlPasteValues
Everyone who confuses correlation and causation ends up dead.
Hi guys,
Apologies for the confusion. I meant to say I declared lastrow and firstrow as variables (not named ranges. Is my request still possible?
I'm quite new to VBA so again apologies for any confusion
How are they declared and what values do they have?
firstrow is always row 4
lastrow will be set my a user input box
Dim firstrow As Long Dim lastrow As Long lastrow = InputBox("Enter Last Row") firstrow = Rows("4:4").Row
Is the number of columns fixed? If so, which ones are they?
Yes, columns A:AT
Dim firstrow As Long Dim lastrow As Long lastrow = InputBox("Enter Last Row") firstrow = 4 Range(Cells(firstrow, "A"), cells(lastrow, "AT")).PasteSpecial xlpastevalues
Thanks :-D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks