I am trying to create a Macro which filters Japanese real estate data
that I copy from the internet into a worksheet. When I record my
actions (e.g. delete contennts of Column C; take the name of the city
from within each line in Column B and copy it into Column A etc.) with
the Macros recorder and play it everything works fine - except the
actions that I did with an Add-In called EasyFilter by Ron de Bruin
MVP...!
I have been told that the reason for this is because I cannot create a
Macro that relies on an Add-In. Therefore, I need to actually do the
action that I would otherwise get EasyFilter to do automaticallly for
me, or write the appropriate lines into the VBA code that is created by
the Macro recorder. The action that I get EasyFilter to do is to simply
delete every line in the whole worksheet where there is a space in
Column D. How can I get the Macro to find all lines in a 25,000 or so
line long worksheet where there is a space in Column C and delete that
line?
Can anyone help me, please?!? I can send you the Excel sheet if you
like - just send your e-mail address to:
