Cell offset based on number of cells in selection

[jerrydiaz]

Hi Guys--

I am working on a macro and this section has me stumped. The worksheet columns are A:AE. Occasionally, the procedure needs to select a varying number of cells in a row which don't always fall in the same column, count the number of cells in the selection and then paste the data on the row above it, in column ("AE" minus the Selection Count).

Here is what I have so far:

Please Login or Register  to view this content.

The red-bold bracketed code is the syntax I'm not able to figure out how to phrase.

Can anyone help?

Thanks
Jerry

[Leon V (AW)]

AE needs to be a number. 31

Edit: or you can do range("AE:AE").column

[jerrydiaz]

Would you please show me the syntax? When I use

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

It pastes into column AF (which makes no sense to me at all).

[jerrydiaz]

Can anybody help me please?

[Leon V (AW)]

your code should select 1 row up on column 61 and paste.

Is this what you are trying to do?

Please Login or Register  to view this content.

[jerrydiaz]

Leon - thanks. The code works when I manually select and cut cells and then run it
but when I preceed it with

Please Login or Register  to view this content.

it only pastes the first cell's contents into the last column of the prior row.

[Leon V (AW)]

what are you trying to achieve with this line?

Please Login or Register  to view this content.

[jerrydiaz]

Select and cut all data in a row, where

• the number of cells to be selected varies
• there are blank cells within the desired selection, and
• the first and last column letter is not always the same

[protonLeah]

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

[Leon V (AW)]

so something like this?

Please Login or Register  to view this content.

[jerrydiaz]

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

I'm not sure what you're talking about protonLeah. I didn't attach or post pictures of anything. If I had, I'm quite aware of how to do so.

[jerrydiaz]

Leon, that's the exact code you posted originally except for the "clear contents" part
I made it work though by modifying the method I use to select the data.

Thanks for your help man!