Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
loca23 23 ani
 | Femeie
23 ani
Cluj
cauta Barbat
23 - 44 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 739
|
|
I run a code that extracts some data, creates new rows on top of a Table and pastes the new data in those rows.
Some columns remain empty, requiring me to run another code based on values in one column.
My first code adds data to columns A:D, then leaves columns E:G empty, and continues adding data to columns G:L. This spans on several rows, in a dynamic range.
After running this first code, I have to manually select the new entries in column D and run another code that does something based on those entries and enters data in the remaining empty columns - E:G.
I want a snippet that selects the newly added entries in column D and calls the other macro automatically. Because why? Because manually selecting you can make errors, like selecting the header value by mistake, or a value that was not newly added.
My table has its header in row 3, so first row with values is row 4. I update the data daily, and I don't get more than 100 new entries even if I waited for a week to update the data. Thus, the CountIf formula below doesn't go on a wider range.
CountNew = WorksheetFunction.CountIf(Range("E4:E104"), "")
Range("D4:D" & CountNew + 3).Select
Call NEXT_MACRO |
Source:
|
|
| pus acum 3 luni |
|