Macro with a variable that finds empty cell in a row

**The student** · 04-21-2011, 06:43 AM

Hi everyone,

I never did a macro with a variable and don't know VBA that well. I always record my macros.

I think this one could be an easy one. Can you help?

Column G has cells with values and cells that are empty.

I sort by column G (A to Z), pushes the rows with empty cells in this column to the bottom of list. I then need to cut all these rows with the empty cells in this column (G). Finally I would like the macro to create a new worksheet, name it "Norp", then paste these fields in the "Norp" workesheet.

Very grateful to anyone that help me. Thanks again.

**royUK** · 04-21-2011, 07:30 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!