Evertrue
01-24-2011, 01:43 PM
Hello all
I know this is my first post, but I have been searching for answer to something for couple day now and can't get anything to work.
I am sorting with auto filter.
the L column I amd searching for blanks
The k column I am searching for ends with X
When the filters come up ...
Now in VBA I want to search for the visible rows and fill in column L with 554988.
I have tried a for loop
for i = 0 to I NEED TO COUNT VISIBLE ROW
that is the first issue
the second issue is how do I loop through only the visible cells minus the header and fill them in.
Any help woudl be GREAT!
I know this is my first post, but I have been searching for answer to something for couple day now and can't get anything to work.
I am sorting with auto filter.
the L column I amd searching for blanks
The k column I am searching for ends with X
When the filters come up ...
Now in VBA I want to search for the visible rows and fill in column L with 554988.
I have tried a for loop
for i = 0 to I NEED TO COUNT VISIBLE ROW
that is the first issue
the second issue is how do I loop through only the visible cells minus the header and fill them in.
Any help woudl be GREAT!