excel VBA - searching a range

  • Thread starter Thread starter Zygoid
  • Start date Start date
Z

Zygoid

How would i search a range of a whole column instead of specific cells
like .Range("a1:a300")?
 
..range("a:a")
..columns(1)
..range("a1").entirecolumn

are a few ways.
 
ahhh! Thanks!!

I was trying .Column(1)

i see i neede an "s" in there

Thanks again
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

array to normal version formula 8
2 macro help 7
Excel VBA 1
how to high light cells 7
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel VBA - Problem with Closing Print Preview 0
Excel VBA setting Ranges 2

Back
Top