I look for a possibility to get the row number of a empty row.
I upload the file into this thread?
I look for a possibility to get the row number of a empty row.
I upload the file into this thread?
Try array entering this formula.
If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
(You may have to change the "," argument separators to ";" for your regional settings.)Formula:Please Login or Register to view this content.
Dave
Excuses my Englisch is not very good.
It must start with a button like VBA and not with key press,
Gr. Manado
Heb je vraag beantwoord in VBA-subforum.
Volgende keer wel je vraag hier in het Nederlands en in het VBA-subforum in het Engels graag want dit is het niet-Engelstalig subforum.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Sorry, ben nog niet helemaal wakker.
Is het te verplaatsen zodat het goed komt?
Eh lo org indo ya? pncet ctrl bawah aj mngkn bs tuh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks