How to get my code to find the next blank cell then skip two spaces

**Tishreeb** · 01-23-2023, 03:17 PM

Hello, I created an input form that takes what I type into the boxes and enters it into another excel sheet, I was trying to figure out how I could have some columns skip two rows after finding the next blank cell. This is the code that i currently have.

Please Login or Register  to view this content.

**jolivanes** · 01-23-2023, 03:41 PM

Change the "Offset(1)" to "Offset(2)" for 1 blank, "Offset(3)" for 2 blanks etc.

**Tishreeb** · 01-23-2023, 04:22 PM

Thanks a lot that worked

How to get my code to find the next blank cell then skip two spaces

LinkBack

Thread Tools

Rate This Thread

Display

How to get my code to find the next blank cell then skip two spaces

Re: How to get my code to find the next blank cell then skip two spaces

Re: How to get my code to find the next blank cell then skip two spaces

Thread Information

Users Browsing this Thread

Similar Threads

Trying to find solution for blank spaces

To Skip Empty Cells & blank Spaces and Capture Values

[SOLVED] Skip code if cell value = 0 or if find value results in nothing

Need to modify code to skip blank rows and headings

[SOLVED] Need to add skip blank cells to my code

[SOLVED] Skip blank spaces in data validation list

[SOLVED] Skip Section of Code if Filter Returns a Blank

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions