Using code to select cells that are two cells to the left of the currently active cell

**LaffyAffy13** · 06-25-2013, 11:55 AM

Hello,

I have a macro that looks specifically for the two characters "1F" in column C of my excel file. When it finds a cell containing 1F, it selects the cell and moves it to another sheet, but I have important information in columns A and B that I want to move with it. Is there a way to command my macro to select all three adjacent cells in A, B, and C whenever it finds a 1F in column C? I can reword if that is too confusing to understand. Thank you in advance!

**Norie** · 06-25-2013, 12:03 PM

Can you post your current code?

In general to select the 2 columns to the left, and include the original column you would use something like this.

Please Login or Register  to view this content.

That's how you would select but you rarely, if ever, need to select.

**AB33** · 06-25-2013, 12:04 PM

Assuming your find set is called findme.

Please Login or Register  to view this content.

**Richard Buttrey** · 06-25-2013, 12:04 PM

Hi,

One way, assuming you are copying or cutting that cell would be to use something like

Please Login or Register  to view this content.

**LaffyAffy13** · 06-25-2013, 12:27 PM

I think Norie's post helps me the most. But my code is this:

Please Login or Register  to view this content.

**AB33** · 06-25-2013, 12:40 PM

Assuming you want to copy and paste

Please Login or Register  to view this content.

**Norie** · 06-25-2013, 12:44 PM

Are you always copying to BITmove?

By the way, why are you repeating the loop if you find '1F'?

If you wanted to copy columns A,B and C from 'zEXP' to 'Overview' starting at X15 and going down try this.

Please Login or Register  to view this content.

If that's not what you want can you explaing further?

**LaffyAffy13** · 06-25-2013, 01:18 PM

Alright. I messed around with my code a little bit and came up with this. I still need to find a way to move the other two cells with the one in column C. Sorry for the confusion.

Please Login or Register  to view this content.

Norie: I have no idea what "Are you always copying to BITmove?" means.

AB33: I think the code you gave me will work, but I had to change a few things to mine so I'm not sure how to fix that exactly.

Thanks again guys

**AB33** · 06-25-2013, 01:29 PM

Please Login or Register  to view this content.

**LaffyAffy13** · 06-25-2013, 01:38 PM

That worked perfectly, thanks a lot AB33

**Norie** · 06-25-2013, 01:56 PM

That was a typo.

It should have been always copying to X15 on 'Overview'.

Anyways, the only part missing from my code was the paste special.

Using code to select cells that are two cells to the left of the currently active cell

LinkBack

Thread Tools

Rate This Thread

Display

Using code to select cells that are two cells to the left of the currently active cell

Re: Using code to select cells that are two cells to the left of the currently active cell

Re: Using code to select cells that are two cells to the left of the currently active cell

Re: Using code to select cells that are two cells to the left of the currently active cell

Re: Using code to select cells that are two cells to the left of the currently active cell

Re: Using code to select cells that are two cells to the left of the currently active cell

Re: Using code to select cells that are two cells to the left of the currently active cell

Re: Using code to select cells that are two cells to the left of the currently active cell

Re: Using code to select cells that are two cells to the left of the currently active cell

Re: Using code to select cells that are two cells to the left of the currently active cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions