VBA - Finding Next Empty Row

This is a discussion on VBA - Finding Next Empty Row within the Excel Questions forums, part of the Question Forums category; Hi all,
Here is a VBA query which probably has a simple solution...
I have designed a user form which ...

VBA - Finding Next Empty Row

Hi all,

Here is a VBA query which probably has a simple solution...

I have designed a user form which when you enter data into it and hit "ok" it sends the information to a worksheet named "data". For each new record entered into the form, the code I have used looks for the next empty row in the "data" sheet and adds the information. Here is the code:

My problem is I need this to look for the next empty row, but start inputing the data in column B and leave column A blank. At the moment it sends the data to the first blank row starting in column A. I would have thought simply changing the range from Range("A:A") to ("B:B") would work but it doesn't. I have tried using the offset function but this also has not worked as my coding was probably incorrect. Any suggestions? Thanks.

Re: VBA - Finding Next Empty Row

- Posting guidelines, forum rules and terms of use- Try searching for your answer first, see how- Read the FAQs- List of BB codes- Please use [CODE] [/CODE] tags when posting your VBA code. It retains spacing, so your code is easier to read, and therefore easier to debug.- Please back up your file before using any macros suggested!