LinkBack URL
About LinkBacks
I'm looking for the VBA to go to a row based on the value in a cell (P5). If P1=5, goto row 5.
Thank you!
I'm looking for the VBA to go to a row based on the value in a cell (P5). If P1=5, goto row 5.
Thank you!
Last edited by jwlamb; 11-25-2014 at 11:38 PM.
As a workaround, I needed to select text in col A:F with the row based on P1 value. So in Q1, =CONCATENATE("A"&P1&":F"&P1), then VBA Range(Range("Q1").Value).
Do you mean you want to select that row? The whole row, or just one cell? Will this be part of another macro, or stand on its own?
This will select the first column of that row. This will work in a worksheet module for the worksheet containing these cells. It can also be used in a Module to apply to the active worksheet.
To select the whole row
Please Login or Register to view this content.
Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
It's part of a userform that when they click submit, it'll strikethrough the row, but only columns A:F.
I responded based on your first post. Your second post is rather different. Try this. No need to use Q1 as an intermediate step.
Please Login or Register to view this content.
Yes.... I was trying to do it the other way around A & Row & :F & Row. I guess I'm not as excel savvy as the rest.
Thank you!
You could do it that way, just a matter of preference, but you can still bypass Q1.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks