Macro on Specified cells

Hi, max548,

I assume that your active cell when starting the macro is C2. Code goes into a normal modiule not behind a sheet. In this case I would start at the bottom of the list and work my way towards row 2:

Please Login or Register  to view this content.

Ciao,
Holger

Hi, max548,

the posted code used

Please Login or Register  to view this content.

for getting into Column B (-1 after the comma means one Column to the left), you might need to change it to read

Please Login or Register  to view this content.

for placing the value in Column C.

Ciao,
Holger

Hi Holger,

Can u check this code . i want to run this macro on D2,D3...so on. where D2 is the active cell.. i want to run the
macro for the whole column at once instead of each individual cell .

Hi, max548,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Ciao,
Holger

Hi, max548,

as far as I remember you may apply the TextToColumns to the whole area at once while I´m having trouble to imagine a way to insert rows and different contents in one take. You might like to use an array or dictionary to do so in VBA: read in the contents ot the sheet, work on the data, write back to the sheet.

Ciao,
Holger