How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
Ask Rafi Your Own Question
Rafi
Rafi, IT Engineer
Category: Programming
Satisfied Customers: 15997
Experience:  IT Manager
106284071
Type Your Programming Question Here...
Rafi is online now

How do I run a macro at a certain position? So I want to be

This answer was rated:

how do I run a macro at a certain position? So I want to be able to select a cell .. . any cell ... and then run it there at that position??
JA: Is there a specific language you're coding in?
Customer: excel vba
JA: When did you last update Excel?
Customer: at work I'm using 2013 version at home 2019
JA: What have you tried so far with your Excel?
Customer: a lot of different things
JA: Anything else you want the Software Expert to know before I connect you?
Customer: no

Hello this is Rafi, IT Specialist with 10+ years of experience. I am currently reviewing your question. Please note that Secure Remote Assistance are auto-generated and communication through chat is fine with me.

Please do the following:

- Click anywhere in Macro1.

- Press F8 to start single-step mode.

- There will be a yellow arrow to the left of the line Sub Macro1().

- Drag this arrow down to the line where you want to start. Make sure that it makes sense to begin here!

- Press F5 to run.

Rafi and 3 other Programming Specialists are ready to help you
Customer: replied 1 year ago.
ok

I'm going to decline the premium service which I don't believe we would need it here and don't want you to get billed extra.