Posts by agog1

See the attachments
details are given on the same
and plz check the row if the row is unhighlighted
Then simply copy and paste the row dont divide it see the data

See the attachments
details are given on the same
and plz check the row if the row is unhighlighted
Then simply copy and paste the row dont divide it see the data

this code is not working see the sample file

I will make a seperate button for ur code and i will assign ur code and after click this button all buttons in my workbook will run step by step
step by step means first it will run step 1 button after its completed its work then step2 will run after its completed the work then step 3 will run and so on upto step 5

I have vba code assigned buttons in my workbook
i have 4-5 buttons
My button name is Step 1 , Step 2, Step 3 and so on
What i want is click the button 1 by 1 means click step 1 button after the work is over run Step2 button if its over run step3 button and so on
These button are on different different sheets but we can make the code bcoz its in series
step 1, Step 2 , Step 3, Step 4 and so on

I want to clear the cells that are not highlighted
Don't delete the cells only clear the cells, make the unhighlighted cell empty in complete sheet

Thnx

Thnx

If true is found in any cell, anywhere in a sheet then clear the content of that sheet completely means clear all the data in that sheet, make a sheet blank

I don't want to delete 1 by 1
i have to run the code once and all the row that contains 12 should be deleted i want that

Find 12 in the sheet if 12 is found then delete that complete row

Ur code is not working u wanted my code so see the attachments

Ur code is not working

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

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

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 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

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

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

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