Selecting used cells in a column

[subbby]

I had a code written where the User gets to choose the range of values.

I have automated it since and now want the prgraom to pick the values from a column without asking the user.

The code I have

Please Login or Register  to view this content.

I tried to two different sceanrios in teh above code

Please Login or Register  to view this content.

and also

Please Login or Register  to view this content.

both cases excel gives an error saying Object Required .. Block variable....

Its a small fix but not having a background in VBA coding, I am little stuck up here.

Any help is much appreciated

-Subbby

[davesexcel]

Please Login or Register  to view this content.

[subbby]

Please Login or Register  to view this content.

Pointing towards 'r' and saying invalid qualifier

[subbby]

This is the code I have

Please Login or Register  to view this content.

Its point at 'r' and giving the error "Invalid Qualifier"

[davesexcel]

r is not a range, it is the row number of the last row in column B

[subbby]

r is not a range, it is the row number of the last row in column B

Not sure, what code modification I should be doing to make it work.

Any help , much appreciated !

Thanks,

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


AddFile.jpg
To add a file to a post

[subbby]

Attaching a sample workbook enables others to work on your problem:


To add a file to a post

I humbly apologize for that. I should have put up a excel sheet as I did in the past.

However, I have solved this one.

i used

Please Login or Register  to view this content.

and it worked.

Thanks for your time and efforts

appreciate it

-Subbby