Re: Loop until cell is empty

Hi JLatham,
I've tried your suggestion. If someone made changes within those cells,
this code would jump only to the first cell that <> s2, make the change,
then it stops. I'm trying to get the code to continue jumping up to the
next <> s2 cell and keep making more changes. Any ideas?

Thanks in advance,
Ricky


*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Color a single digit in a mult-digit number cell
    ... Microsoft MVP - Excel ... A suggestion is to copy the ... > not type anything but choose something under Format (for example Font ... For example, if I type 346 in a cell, I would ...
    (microsoft.public.excel.misc)
  • Re: dropdown list to a page in worksheet
    ... I followed Aladin's suggestion and added IFto check for a blank cell so ... If ranges are not named, ... I have a Page for each name in Worksheet2 ...
    (microsoft.public.excel.newusers)
  • RE: How to modify the web link for retrieving data from external s
    ... If I would like to refer specific sheet, do you have any suggestion on how ... cell A1 on a sheet. ... Then Record a macro to do what you want to do. ...
    (microsoft.public.excel.misc)
  • Re: Question about multiple IFs
    ... Thanks for the suggestion, I am sorry I don't understand it. ... "Don Guillett" wrote: ... "Roger Govier" wrote: ... Did you try what I suggested, copying my formula to Cell B2 on Sheet2 ...
    (microsoft.public.excel)
  • Re: Grow a range by # of lines by right click on grow tool & type
    ... If we're talking about *filling*, there's a dialog box that can help you *fill* easily and quickly, if you're looking to go down a 1,000 rows or across a couple hundred columns, and accomplish this without having to "drag" the cells. ... When I try what you suggested, I just get the value in the cell repeated, ... > Jaleel's suggestion, it gets me there. ... >> This post is a suggestion for Microsoft, ...
    (microsoft.public.excel.misc)