Very Small Error In Uniques arrangement Code, Need correction

**structo** · 09-16-2016, 05:29 AM

Hi Friends,

I have face small problem with Unique arrangement Code. problem is existing text is erased and un necessary Text was created at D2 cell. may be its requires small correction in my code.

please find sample worksheet and please correct by modification.

Thanks.

**mangesh.mehendale** · 09-16-2016, 05:41 AM

If I am checking correct code in workbook then there is problem Cells(i+4, "D") it should be Cells(i+4, 4) coz number of Col D is 4

Please Login or Register  to view this content.

**structo** · 09-16-2016, 05:45 AM

Originally Posted by mangesh.mehendale

If I am checking correct code in workbook then there is problem Cells(i+4, "D") it should be Cells(i+4, 4) coz number of Col D is 4

Hello friend,

thank you for explanation, good points. after using your code same error is came kindly test.D2 cell existing text is erased and pasted as "Type3 Books". please fix.

Thanks.

**zbor** · 09-16-2016, 05:45 AM

Start from 3rd row. Not 2nd:

Please Login or Register  to view this content.

**jindon** · 09-16-2016, 05:45 AM

http://www.excelforum.com/excel-prog...to-larger.html

Change to

Please Login or Register  to view this content.

**structo** · 09-16-2016, 05:46 AM

Originally Posted by mangesh.mehendale

If I am checking correct code in workbook then there is problem Cells(i+4, "D") it should be Cells(i+4, 4) coz number of Col D is 4

Hello friend,

thank you for explanation, good points. after using your code same error is came kindly test.D2 cell existing text is erased and pasted as "Type3 Books". please fix.

Thanks.

**structo** · 09-16-2016, 05:47 AM

Originally Posted by jindon

http://www.excelforum.com/excel-prog...to-larger.html

Change to

Please Login or Register  to view this content.

Hello Jindon friend,

i am modifying your old code

How to change your code? where it is placed?

Thanks.

**jindon** · 09-16-2016, 05:49 AM

Deleted............

**jindon** · 09-16-2016, 05:50 AM

Please Login or Register  to view this content.

Should be r.Value not e

**structo** · 09-16-2016, 05:55 AM

Originally Posted by zbor

Start from 3rd row. Not 2nd:

Thank you friend, now it is worked.

Thanks.

**structo** · 09-16-2016, 05:58 AM

Thank you, Jindon, mangesh.mehendale, zbor.

Very Small Error In Uniques arrangement Code, Need correction

LinkBack

Thread Tools

Rate This Thread

Display

Very Small Error In Uniques arrangement Code, Need correction

Re: Very Small Error In Uniques arrangement Code, Need correction

Re: Very Small Error In Uniques arrangement Code, Need correction

Re: Very Small Error In Uniques arrangement Code, Need correction

Re: Very Small Error In Uniques arrangement Code, Need correction

Re: Very Small Error In Uniques arrangement Code, Need correction

Re: Very Small Error In Uniques arrangement Code, Need correction

Re: Very Small Error In Uniques arrangement Code, Need correction

Re: Very Small Error In Uniques arrangement Code, Need correction

Re: Very Small Error In Uniques arrangement Code, Need correction

Re: Very Small Error In Uniques arrangement Code, Need correction

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Extract uniques and sort as a Smaller to larger

[SOLVED] Edit a small code to remove error

[SOLVED] Sort small data

[SOLVED] Error in Code to Sort, Hide, and PDF Worksheets

Help me sort this code layout error! Missing inverted comma!

Can this small bit of code be combined to one line of code?

I have a small error in the macro......help me please

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions