Activate cell

    My data in
    column A
    1
    2
    4
    5
    7
    8
    4
    3
    2
    1


    What i want is to to click on each cell so that they can be activated
    All data is in Column A
    only i have to click on each cell so that they can be activated and 2nd thing my data doesn't consist formula

    What do you mean by "activated"? Once you click on a cell it is activated.

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

    Yes i want to do the same in complete columnA till the end of data i have to click each cell and activate the cell i need a vba code bcoz there r lots of data in column A

    Agog,


    When you click on a cell ... it is activated.


    What are you wanting code to do.

    U r right but if u have data in complete column A
    then u will not go to each cell and click on cell and activate it am i right so i need the code to do the same

    I want the code that activate the cell of all data in cloumnA
    columnA
    1
    2
    4
    5
    6
    7


    Loop till the end of the data with activating all the cell in Column A

    I'm sorry but it is still not clear what you want to do. The problem is what you mean by "activate". In Excel terms, "activate" means selecting the cell so that it is the active cell. When you select a cell and make it active, you will see a border around it. Can you describe in more detail exactly what you want the macro to do? Do you want to loop through column A and copy each cell and then paste it somewhere else? Do you want to change each cell's formatting? This is the type of information that we need to help.

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

    I am having the data but vba code is not working
    vba code is not working bcoz it can't read the data
    It cant read the data bcoz the cell is not activated
    Cell is not activated means for activating cell i have to go to each cell in column A and i have to left click on the mouse and after that that vba code is working
    So thats y i want to activate all the cells in column A
    Means go to each cell in column A and left click the mouse 2 times in each cell do this till the end of the data
    If u can't understand what i am saying is
    Make a code for the same procedure which i have mentioned go to each cell in Column A and left click the mouse two times and move to next cell do this till the end of the data

    Can you post the code you are currently using?

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

    Code is fine sir i have checked all the things in different file that code is working i have used concatenate formula in column A thats y they r inactive
    Kindly make the code of the same procedure rest i will take care of it

    I thought that by looking at your code I could get a better idea of what you are trying to do because I still don't understand. Perhaps someone else in the Forum will be able to help you.

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

    Code
    For each cell in worksheets("NameHere").range("FirstACellHere", worksheets("NameHere").Range("A" & rows.count).end(xlup))
' Your code here
Next cell

    U know how to activate the formula
    by pressing F2 key
    The same this is not the formula this is the number
    i think u don't know vba

    I don't want to put the code without code we can't do it bro let's make it simple and clear
    columnA
    1
    2
    3
    4
    5
    6
    And so on



    Just go to each cell in columnA means go to 1,2,3,4,5,6 and so on and left click the mouse 2 times in each cell and go to next cell do it till the end of the data


    It's simple and Clear any question in this?
    make a vba code for this procedure
    I have mentioned what to do

    Code
    For each cell in worksheets("NameHere").range("FirstACellHere", worksheets("NameHere").Range("A" & rows.count).end(xlup))
   ' Your code here      
      cell.activate
     cell.clearcontents
Next cell

    Agog,


    What you've attached as code is not the same as what I posted. Maybe post a sample workbook of the data and what you are wanting? I'm baffled by your code and what you're trying to do.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login