Row copy followed by row insert pastes row instad of just inserting empty row

**nosense** · 08-20-2015, 04:26 AM

This macro gets on my nervs. This suppose to Copy the row for which IF statement is met and then if same statement is met insert the empty row , but instead it does paste this copied row right away

1.xlsm

Please Login or Register  to view this content.

**skywriter** · 08-20-2015, 04:36 AM

You have 70 posts.
Read these.
#3.

**LokeshKumar** · 08-20-2015, 04:43 AM

Hi Stan Kuncik,

I do not understand your requirement but try this one.....

Please Login or Register  to view this content.

**Parth007** · 08-20-2015, 04:46 AM

Please use codetags by pressing (#)

Please Login or Register  to view this content.

try this..below line added to ur code..

Please Login or Register  to view this content.

Row copy followed by row insert pastes row instad of just inserting empty row

LinkBack

Thread Tools

Rate This Thread

Display

Row copy followed by row insert pastes row instad of just inserting empty row

Re: Row copy followed by row insert pastes row instad of just inserting empty row

Re: Row copy followed by row insert pastes row instad of just inserting empty row

Re: Row copy followed by row insert pastes row instad of just inserting empty row

Thread Information

Users Browsing this Thread

Similar Threads

I need a macro that pastes a selected range in the next empty cell until row 2000

Strings instad of numbers after Case is? and wish to include more Colunms

[SOLVED] Macro that pastes from the clipboard into the next empty cell in a column

[SOLVED] Code that copys the first row in my spreadsheet and pastes it in the first empty row avail

A macro that copy and pastes to line below but pastes in a Values and numbers format

A macro that copy and pastes to line below but pastes in a Values and numbers format

[SOLVED] Automating a macro that copies and pastes data and pastes 2 rows under the previous one.

Bookmarks

Bookmarks

Posting Permissions