Dear Members,
I need your help to fix an issue I have in a Macro.
I am collecting data from a table (Time sheets) and I need to record the values in a Database (Time sheets registration). The maximum values I am planing to record are 16.
I have created one macro that inserts 16 new rows in "Time sheets registration", then it copies the data from "time sheets" and will paste it in the database.
Since the amount of data to be copied is not fixed ( it can be any number between 1 and 16) I have tried to include in my macro a way to select and erase the empty cells. The problem I have is that the macro doesnīt recognize the empty cells.
is there any way to program the macro to select only cells with information?
Thanks all in advance
Bookmarks