How to modify the macro to work regardless of the row number?

**ivaylos89** · 03-12-2024, 12:02 PM

Hey, everyone,

This is my macro and as you can see it works for the first 782 rows. How can I modify it to work regardless of the row number?

Please Login or Register  to view this content.

**romperstomper** · 03-12-2024, 12:06 PM

Try using:

Please Login or Register  to view this content.

instead of:

Please Login or Register  to view this content.

**ivaylos89** · 03-12-2024, 01:39 PM

Hello,

I had to redo the macro and I changed the line with yours but now it's glowing in red.

Attachment 862587

When I run the macro I get an error:

Compile error:

Syntax error

**ivaylos89** · 03-12-2024, 01:53 PM

I managed to fix it.

I'm not sure how the "=" appeared before "Table3"

It's working now, thank you!

How to modify the macro to work regardless of the row number?

LinkBack

Thread Tools

Rate This Thread

Display

How to modify the macro to work regardless of the row number?

Re: How to modify the macro to work regardless of the row number?

Re: How to modify the macro to work regardless of the row number?

Re: How to modify the macro to work regardless of the row number?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Modify Order Number Column based on Zip Code Column

[SOLVED] Need someone to edit Modify Macro's to work on entire work book

Modify Macro to work anywhere on wooksheet not just in specific cells

[SOLVED] Modify This Macro To Generate More Than 1048576 Number Sets

Modify macro to work with larger data.

[SOLVED] Help to modify Macro - delete rows that DO NOT contain a negative number.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions