How
I have a formula that automatically complete 500 cells in a row
for example if a1 is true, then write 2 for 500 cells
but then to go to the cell 501 I have to move manually the cursor at the cell 501
How to move the cursor automatically to the cell 501 when the formula is true?
Thanks!
Sheet1.Range("A501").Activate
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
where do I write this??
this is my formula pasted for 500 cells:
in spanish excel..
Please Login or Register to view this content.
Sorry, that is for VBA code.
above cell A1 is a small text bar that you can type a cell reference in and then enter and it will take you directly to that cell. ie: A501
It is the one to the left of the formula bar.
but i want that it works when the formula is true!
for example:
I am in A2
In A2 I have this formula
If I write 2 in A1, then excel write 2 in A2 and excel bring my mouse in A3Please Login or Register to view this content.
Thanks!
I dont think excel allows that action.
You can only do it using vba
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks