Jump to content
Macro Express Forums

Can ME3 find an exact cell in excel ?


Recommended Posts

I'm building a macro to gather data for a report and place it into a template in excel.

Getting the data is fine, but is it possible to have the macro find a cell in excel to paste bits of copied data ?

I know how to get it to open excel etc and I could probably find the right location by building the macro to tab / arrow into certain cells in excel.. but if it could find sell C4 with ease then it would be a quicker / easier time for me.


Any tips welcomed


Link to comment
Share on other sites

There is another way to navigate to a particular cell in Excel, but it doesn't involve Macro Express. The method executes a little quicker, and is not as "flashy" because it doesn't involve the "Go To" dialog box.

1. Expose the "Developer" ribbon in Excel.

2. Click "Developer," and choose "Record."

3. You will be prompted to assign a "Shortcut key" to your macro, Ctrl + something. Choose a combo like Ctrl + forward slash... on any key that that you are unlikely to press by accident.

4. Choose to save the macro in either "This Workbook" (so that the shortcut key will only be available in this workbook); or "Personal Macro Workbook" (so it will be available in other workbooks.)

5. Then use Samrae's method to navigate to the cell: press Ctrl + G, type the cell number, and then press Enter.

6. Click on the "Developer" ribbon, and stop the recording.

7. Then press your shortcut key to activate the Excel macro.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...