Open workbook with the first blank row in a worksheet

[boboivan]

Hello everybody!

When I open my workbook, I'd like to go at the first empty row of the worksheet.
I've tried the below code, but doesn't work. Any ideas? Thanks in advance!

Please Login or Register  to view this content.

[:) Sixthsense :)]

Replace this

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

[boboivan]

Thank you for the prompt answer!

I did what you recommended, but it doesn't work. I pressed ALT+F11 and I inserted the code in the worksheet that I need to be opened.

Please Login or Register  to view this content.

Maybe I do something wrong. Could you please tell me what are exactly the steps I must follow?

[:) Sixthsense :)]

What happens while running the code? Is it showing any error? If so, then click debug and check and confirm in which line the error pops up?

[boboivan]

Nothing happens! No error, no nothing.
I'm expecting the worksheet to get open and mark the first blank cell in column B

[:) Sixthsense :)]

Surely it should throw some errors

[boboivan]

In the same sheet is running another code (see the image!). Could this be a problem?

untitled.PNG

[Izandol]

This code must be in ThisWorkbook module not worksheet module and must be:

Please Login or Register  to view this content.

[boboivan]

Thank you so much Izandol!

In the worksheet a have a table with 3000 rows.
The code opens the sheet with the first empty row outside of the table (row 3001)

[Izandol]

Is this what you wish or not? Code will find last cell with contents in column B and select cell below.

[boboivan]

No, this is what it is and doesn't help me at all to open the sheet with the row 3001. I need to open the sheet with the first empty row in the table.

[Izandol]

Does table have formulas in column B? Why do you have empty rows in the table at all?

[:) Sixthsense :)]

I need to open the sheet with the first empty row in the table.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[boboivan]

The column B has a drop down list created with Data Validation option. I have many formulas in other columns and I needed to preset the number of rows.

[boboivan]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

A sample as a image, or as a XLfile?

[:) Sixthsense :)]

A sample as a image, or as a XLfile?

We never ask for image, since we can't work with it

[Izandol]

Why do you need preset rows? Table is designed to expand when you will add new data.

You may try:

Please Login or Register  to view this content.

[:) Sixthsense :)]

Or

Please Login or Register  to view this content.

[boboivan]

The genius Bernie Deitrick solved the problem again!

Here is the solution:

Please Login or Register  to view this content.

[Izandol]

This is what Sixthsense said before.

Also I think you must read the rules for cross-posting.

[boboivan]

So, the perfect code for this problem (provided by the genius Bernie Deitrick) is:

Please Login or Register  to view this content.

[boboivan]

Or

Please Login or Register  to view this content.

Thank you so much! Indeed, this is the solution.
I don't know what happend with the thread, but I couldn't see any answer from you guys.

[boboivan]

This is what Sixthsense said before.

Also I think you must read the rules for cross-posting.

Thank you too for being so kind to help me and provided a very good solution.
As I couldn't see any answer from you, I asked somebody else via private messages to help me with the matter.
I didn't know also of the cross-posting problem. I've read the forum rules and I'm sorry if I did something wrong. I'm quite new on the forum and I admit that I use it a bit clumsy.