Jump to content
Macro Express Forums

Issues with ME, Excel once I started using VBA


Trixie
 Share

Recommended Posts

Hi,

 

Gosh, it's amazing what kind of communities you can find when you Goggle things!

 

I have been looking for somewhere where someone might have a little expertise with ME & Excel, as I'm one of only a couple in my office who use the combo.

 

I created some ME macros last summer, that have been working just fine thank you until I started adding some formulas, validation & VBA to my workbooks to make them smarter.

 

The issue I am seeing is that when I execute an 'Enter' function at the end of a row in Excel to move back to the beginning of the next row to copy through, it now pastes instead of 'carriage returning'.

 

The Macro Express macro copies & stores each cell between A6 & P6, tabs through to Q6 and then executes the enter function to move back to copy same for rows 7, 8 & 9 before moving to the next application to paste the data. Instead of entering(carriage return) it pastes the last piece of data copied in Q6 and then runs amok.

 

I could work around by changing all of my ME code to <ARROW DOWN><HOME> instead of enter, but lots of updating to do.

 

Has anyone here run into this within Excel? I have had my Excel VBA vetted, and that doesn't seem to be the problem.

 

It's nice to know that you all are out here...I'm going to have to poke around to see what tips I can pick up. ;)

 

Thanks~

Trixie

Link to comment
Share on other sites

Arrow down > home indeed, also there is a command in Excel for 'go to' a certain cell. Keyboard shortcuts are going to be your best friend when using ME with Excel. I recommend anyone using the two brush up on their shortcuts....

 

From http://www.rnib.org.uk/xpedio/groups/publi...rnib003503.hcsp

 

 

Navigating

 

Description

 

 

Shortcut Key

 

Move to next cell in row

 

 

Tab

 

Move to previous cell in row

 

 

Shift + Tab

 

Up one screen

 

 

Page Up

 

Down one screen

 

 

Page Down

 

Move to next worksheet

 

 

Ctrl + Page Down

 

Move to previous worksheet

 

 

Ctrl + Page Up

 

Go to first cell in data region

 

 

Ctrl + Home

 

Go to last cell in data region

 

 

Ctrl + End

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.

Guest
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.

Loading...
 Share

×
×
  • Create New...