Command Code Confusion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been writting code in VB for Access, so I know the docmd. and me.
commands and a few others. Where does one find the commands for Excel. I
tried to write a little macro, (stepping was horrendous) and I was clueless.
Specifically, I wanted to edit the cell, (F2), enter part of a formula, hit
{home} to go to the begining of the cell, and enter the rest of the formula,
then hit enter and move down one row. The formula part is the same for all
cells, so that would be in the code as well, I am not typing it in. I have no
idea where to find the commands to create this macro. Any help would be
greatly appreciated.
 
Do that stuff in Excel with the macro recorder turned on. It will get you
started.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stop Command Question 4
Recording Macro Error Message 1
Access Automatically Send a notification email once a record is added 0
Named Range maker code 9
Command Button Question 8
Insert Row also adds formulas and moves cursor 2
X Cell Problem 9
VBA set thick borders around non empty cells in range 0

Back
Top