Jump to content
Macro Express Forums
Sign in to follow this  
NeVeR

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

thanks.

Share this post


Link to post
Share on other sites

Pressing Ctrl+G or F5 in Excel brings up a dialog box to go to a cell. You can create a macro to type what is needed. Something like this:

Text Type: <CONTROL>g
Wait For Window Title: "Go To"
Text Type: C4<ENTER>

 

Share this post


Link to post
Share on other sites
2 minutes ago, NeVeR said:

didn't know excel had this..

Neither did I before this. Google is your friend. 😉

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×