If test is true, select a range and move all below down

PaulCruice

New Member
Joined
Aug 18, 2006
Messages
15
Am relatively new to VBA so will probably need some real help. The best I can do is describe what I want to do.
I have a vertical list of individual words with any punctuation also occupying its own cell. I want to begin at the top of the sheet and test if A1=any punctuation is true, then select range B1 to C1 and move all these cells in the range and those below down one cell. If B1 does not equal any punctuation then go to A2 and repeat the process through to the end of the document.
Really appreciate some help. Thanks.
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
if B1=any punctuation, if true then select range E1 to N1 and move all these cells and those below down one cell.

____________________________

It's hard to understand. paste an example here.

Best Regards
 
Upvote 0
Northwolves, Thanks for the reply. The following should help.
In the sample below, Column A has a list of Greek words but note that the punctuation is also included. Column B & C are the English translation and notes for each Greek word. What I want to do is insert blank cells in Columns B & C so that the English words and notes correspond with their correct Greek word.

GreekWord1 EnglishWord1 OtherRelevantData1
GreekWord2 EnglishWord2 OtherRelevantData2
, EnglishWord3 OtherRelevantData3
GreekWord3 EnglishWord4 OtherRelevantData4
GreekWord4 EnglishWord5 OtherRelevantData5
. EnglishWord6 OtherRelevantData6
GreekWord5 EnglishWord7 OtherRelevantData7
GreekWord6 EnglishWord8 OtherRelevantData8
? EnglishWord9 OtherRelevantData9
GreekWord7
GreekWord8
GreekWord9
 
Upvote 0

Forum statistics

Threads
1,216,111
Messages
6,128,898
Members
449,477
Latest member
panjongshing

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top