MrExcel Publishing
Your One Stop for Excel Tips & Solutions

excel macro and "shift+end+down"

Posted by Patrick Nowak on September 06, 2001 7:07 AM

Hello, I am new to VBA but our company converted from Lotus to Excel and am making the leap. I need to write a macro where I copy a date to the right of a record in a report having several hundred records. The problem is the records are sometimes one, two, or three lines. In Lotus this was no problem, I simply went to my open column where i wanted to copy the dates, and went used a period to anchor, then right arrow key, end, then down arrow key. I can't figure this out in Excel, and it won't work even using absolute records. It just offsets the number of rows recorded on the first record. Can anyone help me?

Posted by Tom Urtis on September 06, 2001 9:38 AM

Two clarification questions please

Patrick, 2 questions, when you say your report's several hundred records each contain one, two, or 3 lines, do you mean one, two or three rows? If so, if someone were to just view the report, how is a new record recognized (i.e. by some unique ID field, an empty row separating the records, or some other way)?

Tom Urtis