joaofigu78
New Member
- Joined
- May 29, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi there,
i ve a table in excel and i want to fill 2 columns afters export(i ve already the right code).
i wan t fill column 4 and 5 with Text 'Sent' and now() date if null (means not sent yet)
i already filter in vba and also know that it´s colmn 26 and 27. i already search for some code that could help me get there but all i see is related to cells RC. not to a table.
ActiveSheet.ListObjects("Tbl_Consumos").Range.AutoFilter Field:=26, Criteria1:="="
Sorry for my english.
Example:
i ve a table in excel and i want to fill 2 columns afters export(i ve already the right code).
i wan t fill column 4 and 5 with Text 'Sent' and now() date if null (means not sent yet)
i already filter in vba and also know that it´s colmn 26 and 27. i already search for some code that could help me get there but all i see is related to cells RC. not to a table.
ActiveSheet.ListObjects("Tbl_Consumos").Range.AutoFilter Field:=26, Criteria1:="="
Sorry for my english.
Example:
# | Cubicagem | Unidade de Cubicagem | Sent(col 26) | Date(col 27) |
1 | 0,792 | CD3 | ||
2 | 0,792 | CD3 | ||
3 | 0,792 | CD3 | ||
4 | 0,792 | CD3 | ||
5 | 0,792 | CD3 | ||
6 | 0,792 | CD3 | ||
7 | 0,792 | CD3 | ||
8 | 0,792 | CD3 |