Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using up, dwn, end, right, left in vb programming
I would like to set a print area using the arrow keys. If I turn on the
macro recorder it dows not show how the keys sequences are created. What is the vb code to start at cell A10 and range select end down, end right then right once? Thank you for your help in advance!!! (smile) I;m in a real bind.... Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using up, dwn, end, right, left in vb programming
Mike,
Try this: range(range("A10"), range("A10").end(xlDown)).resize(,2).Select John "Michael Kintner" wrote in message ... I would like to set a print area using the arrow keys. If I turn on the macro recorder it dows not show how the keys sequences are created. What is the vb code to start at cell A10 and range select end down, end right then right once? Thank you for your help in advance!!! (smile) I;m in a real bind.... Mike |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using up, dwn, end, right, left in vb programming
Mike,
After re-reading your post, I think that this may do what you want: range(range("A10").End(xlToRight).Offset(0,1), range("A10").end(xlDown)).Select John "John Wilson" wrote in message ... Mike, Try this: range(range("A10"), range("A10").end(xlDown)).resize(,2).Select John "Michael Kintner" wrote in message ... I would like to set a print area using the arrow keys. If I turn on the macro recorder it dows not show how the keys sequences are created. What is the vb code to start at cell A10 and range select end down, end right then right once? Thank you for your help in advance!!! (smile) I;m in a real bind.... Mike |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using up, dwn, end, right, left in vb programming
Still having problems, how do I do two end downs?
"John Wilson" wrote in message ... Mike, Try this: range(range("A10"), range("A10").end(xlDown)).resize(,2).Select John "Michael Kintner" wrote in message ... I would like to set a print area using the arrow keys. If I turn on the macro recorder it dows not show how the keys sequences are created. What is the vb code to start at cell A10 and range select end down, end right then right once? Thank you for your help in advance!!! (smile) I;m in a real bind.... Mike |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using up, dwn, end, right, left in vb programming
Michael,
How is your data set up? The End(xlDown) should get you to the last non blank cell under A10. Is there more information below that (skipping a row)??? maybe this will work (all one line): range(range("A10").End(xlToRight).Offset(0,1), range("A" & rows.count).end(xlup)).Select The above will select Range A10 down to the very last non blank cell in column "A" and one column to the right of the last non blank cell in Row 10. John "Michael Kintner" wrote in message ... Still having problems, how do I do two end downs? "John Wilson" wrote in message ... Mike, Try this: range(range("A10"), range("A10").end(xlDown)).resize(,2).Select John "Michael Kintner" wrote in message ... I would like to set a print area using the arrow keys. If I turn on the macro recorder it dows not show how the keys sequences are created. What is the vb code to start at cell A10 and range select end down, end right then right once? Thank you for your help in advance!!! (smile) I;m in a real bind.... Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LEFT function-all to left of a comma? | Excel Worksheet Functions | |||
when inserting new worksheets they read right to left not left to. | Setting up and Configuration of Excel | |||
My Excel view is Right to Left instead of Left to Right !!! | Excel Discussion (Misc queries) | |||
Column labels run right to left, not left to right | Excel Discussion (Misc queries) | |||
How to change the right-to-left worksheet to left-to-right workshe | Excel Discussion (Misc queries) |