LinkBack URL
About LinkBacks
Hello -
I need to set a range using a variable. Starting with A1 and looping through the first row, I want to set the column to
variable j.
So I need the range to be (j, 1) and then check that column for a particular string.
Thanks
Hello -
I need to set a range using a variable. Starting with A1 and looping through the first row, I want to set the column to
variable j.
So I need the range to be (j, 1) and then check that column for a particular string.
Thanks
something like this
with j being your variable
Please Login or Register to view this content.
Regards,
amotto
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
I'm trying this now and getting syntax error:
Please Login or Register to view this content.
try this
Please Login or Register to view this content.
Getting method 'Range of Object' _Global failed
is j a number or letter?
Josie
if at first you don't succeed try doing it the way your wife told you to
When it stops at the breakpoint, it references column 22...its declared as Integer
then you need to use Cells
Please Login or Register to view this content.
That worked! Thank you!
I looped through the column until I found "POC". Now I need to go back "j" spaces (or "j" - 1) spaces to get the name in the first column.
Trying to do it like this:
Getting application defined error.Please Login or Register to view this content.
Please Login or Register to view this content.
Yes!!! Thank you very much
you're welcome
please don't forget to mark the thread solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks