i have data and show big row
i am copy all data from sheets("DATA") To new sheets
by filter "kelas" but i have problem if using specialcells(12).offset(1)
any data not correct to execute
but if use specialcells(12).offset(0)
data is correct
but i want only from offset(1) how to do ??
in my file in red sheets("kk") and sheets("1d") is not correct
Please Login or Register to view this content.
Last edited by daboho; 02-08-2018 at 06:13 AM.
Without having reviewed the file, perhaps simply
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
xlnitwit , i don't want to copy row(5) or [a5].entirerow
i want olny to copy from Header rows(5).offset(1)
and my asking why
if use specialcells(12).offset(0) data is correct
but if use specialcells(12).offset(1) data is not correct
Did you try what I posted? It should skip the first row.
i am sorri xlnitwit yes
your coding is sucsess thank for your answer
great ide
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks