Lv 2421 points

questionsNanswers

Favorite Answers24%
Answers42
Questions2
  • Write a macro to number cells...?

    I am trying to write a macro that will number each cell in a column (1,2,3,4,5...) until the cell to the right of it is empty.

    The cells need to be numbered in column A and it must always check column B to see if it is empty or not. The cells being numbered must begin at the ActiveCell and the range of cells being numbered will change. So if B1 is not empty paste "1" in A1 then if B2 is not empty paste "2" in A2...etc until Bsomething is empty.

    Example:

    Column A Column B

    1 Apple

    2 Bananna

    3 Cay

    4 Dog

    5 Elf

    6 Fruit

    1 Apple

    2 Bananna

    3 Cat

    1 Apple

    2 Bananna

    3 Cat

    4 Dog

    I was thinking a Do...loop with an If statement embedded.

    Help...thank you.

    1 AnswerProgramming & Design1 decade ago
  • They changed my apartment building into a pet friendly zone without any notification, can they do this?

    I have lived in this apartment for a year and a half. I just renewed my lease. I specifically chose a non-pet zone because I work nights and need to sleep during the day. There is now a dog that barks during the day living in the apartment next to me (just moved in). They changed our building into a pet friendly zone two months ago. No one ever notified me of this change. Can they do this?

    5 AnswersRenting & Real Estate1 decade ago