I have workbook with sheets CustomerA and Report .
So far I have 915 rows when applying code but if no of rows in red are dynamic that is it can can be 100 or 500 or 20000 instead of 915 as e.g .
How to make column J,K,L and W and AD dynamic instead of static(in red) with actual code.
The criteria to last row of data is column C
Row 1 are headers
Please Login or Register to view this content.
You will have to do a row count and use the value instead of 915
Please Login or Register to view this content.
Last edited by Bernie Deitrick; 10-30-2018 at 12:55 PM.
Bernie Deitrick
Excel MVP 2000-2010
Edit: answered, long delay on my internet for some reason
Last edited by nigelog; 10-30-2018 at 10:53 AM.
Hi Bernie
Tested code, got message pop up compile error End If without block if .
Please Login or Register to view this content.
Sorry - I had a brain freezer. Change 'If' to 'With' as in
End With
not
End If
Perfect Bernie Thank you a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks