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
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.
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.
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?
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.
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
Ur code is not working
Ur code is not working u wanted my code so see the attachments
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.
Don’t have an account yet? Register yourself now and be a part of our community!