Last Column count based on find.row count

**Sc0tt1e** · 03-23-2014, 10:14 PM

I'm not sure how to colour the line but the "LastNumba" line of code is causing me some grief. I've tried to replicate the Rownumba format but I can't quite get it right. Can anyone help me work out how to find the last cell with a value in it using the row found in row number, and then allow me to use it as ColRef so I can paste a value into the result?

Please Login or Register  to view this content.

**Norie** · 03-23-2014, 10:17 PM

If you want the column number use the Column property.

Please Login or Register  to view this content.

**Sc0tt1e** · 03-23-2014, 10:27 PM

Originally Posted by Norie

If you want the column number use the Column property.

Please Login or Register  to view this content.

I tried that already. I get a run time error 1004, Application-Defined or Object-Defined error

**Norie** · 03-23-2014, 10:30 PM

Perhaps you should add Option Explicit at the top of the module.

That would help you find any misspelt/undeclared variables, e.g. rownumber.

**Sc0tt1e** · 03-23-2014, 10:37 PM

I don't know what that does but I have added it, I have also spelt Rownumba correctly however I am still getting the same error message but on a different line now?

Please Login or Register  to view this content.

**Sc0tt1e** · 03-23-2014, 11:01 PM

Never mind I was being an Idjut, got it sorted at last

Last Column count based on find.row count

LinkBack

Thread Tools

Rate This Thread

Display

Last Column count based on find.row count

Re: Last Column count based on find.row count

Re: Last Column count based on find.row count

Re: Last Column count based on find.row count

Re: Last Column count based on find.row count

Re: Last Column count based on find.row count

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] To find the count based on data and criteria.

[SOLVED] count strings based on dates if find duplicate consider it one

[SOLVED] Count Rows Based On User Input & Trigger Print Of Pages Out Of Count Result

function to find out count based on criteria.

How do i count numbers and letters to find a total count of all

Bookmarks

Bookmarks

Posting Permissions