[SOLVED]: extraneous data in macro recorder


The Code Cage - Microsoft Office help
      Free Microsoft Office Help for all Applications!

Excel VBA Help
Technical Support
 


To stop seeing these ads and get other benefits check This page!
Automatic Translations (Powered by Powered by Google )
Catalan Chinese Croatian Czech Danish Dutch English Finnish French Galician German Greek Hindi Indonesian Italian Japanese Korean Latvian Lithuanian Norwegian Persian Polish Portuguese Romanian Serbian Slovak Slovenian Spanish Swedish Thai Turkish Ukrainian Vietnamese

Go Back   The Code Cage Forums > Resource Forums > Microsoft Office Topics Archive > Excel Archives
Reload this Page

[SOLVED]: extraneous data in macro recorder

Page showing the last 10:-
  




Excel Archives All Older Excel threads are saved here in one forum

Closed
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 20th July 2009, 00:09
Gary Keramidas's Avatar
Gary Keramidas
Newsgroup Contributor
  
Posts: n/a
My Top Tip Count:
Default [SOLVED]: extraneous data in macro recorder
     

can someone tell me why my macro recorder is doing this?

VBA CODE:
 
Columns& VB_VarUserMemIdA: CVB_VarUserMemId '+Select
Selection+Sort Key1 .<= Range&VB_VarUserMemIdC2VB_VarUserMemId 'VB_VarProcData _
Order1 .<= xlAscendingVB_VarProcData Header .<= xlGuessVB_VarProcData _ 
OrderCustom .<= 1VB_VarProcData MatchCase .<= FALSEVB_VarProcData Orientation . _ 
<= xlTopToBottomVB_VarProcData DataOption1 .<= xlSortNormal
--

Gary Keramidas
Excel 2003


Did you find this post helpful? Yes | No
The Code Cage Advertisment
Advertisement

To stop seeing these ads and get other benefits check This page!
  #2 (permalink)  
Old 20th July 2009, 00:36
stanleydgromjr's Avatar
Junior Member
MS Office Version: MS Office 2003, 2007
MS Office Skill Level: Proficient at manipulating data
  
Join Date: Jul 2009
Location: Northeast Pennsylvania, USA
Posts: 56
My Top Tip Count: 0
Thanks to others: 0
Thanked 0 Times in 0 Posts
Reputation: 22 (3) stanleydgromjr is on a distinguished road
USA
Default Re: extraneous data in macro recorder
------ Register to get rid of these "In Post" ads! ------


Warning

Warning



Sorry but you need to register for FREE to see the rest of these posts. Please click HERE to register.

We only allow guests to see the first post of every thread to keep valuable resources for our members.







Did you find this post helpful? Yes | No
  #3 (permalink)  
Old 20th July 2009, 01:56
Gary Keramidas's Avatar
Gary Keramidas
Newsgroup Contributor
  
Posts: n/a
My Top Tip Count:
Default Re: extraneous data in macro recorder
------ Register to get rid of these "In Post" ads! ------


Warning

Warning



Sorry but you need to register for FREE to see the rest of these posts. Please click HERE to register.

We only allow guests to see the first post of every thread to keep valuable resources for our members.







Did you find this post helpful? Yes | No
The Code Cage Advertisment
Advertisement

To stop seeing these ads and get other benefits check This page!
  #4 (permalink)  
Old 4th August 2009, 00:23
Jim Cone's Avatar
Jim Cone
Newsgroup Contributor
  
Posts: n/a
My Top Tip Count:
Default Re: extraneous data in macro recorder
------ Register to get rid of these "In Post" ads! ------


Warning

Warning



Sorry but you need to register for FREE to see the rest of these posts. Please click HERE to register.

We only allow guests to see the first post of every thread to keep valuable resources for our members.







Did you find this post helpful? Yes | No
The Code Cage Advertisment
Advertisement

To stop seeing these ads and get other benefits check This page!
Closed
The Code Cage at Facebookhe Code Cage at Twitter


Tags
data, extraneous, macro, recorder

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

The Code Cage Affilliates
xlDynamic, The Code Cage Hosting Services, Remortgage Offers.co.uk - Mortgages - Remortgages - Loans & Buy To Let Deals - Free Mortgage Advice


To stop seeing these ads and get other benefits check This page!



All times are GMT +1. The time now is 05:03.

The Code Cage - Microsoft Office Help - Microsoft Office Discussion - Archive - Privacy Policy - Terms of Service - Top

Translations made by vBET 3.5.4
Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.6.0
Template-Modifications by TMS
No part of this board may be copied or reproduced either in part or full without the express permission of The Code Cage Team.
Copyright © 2008 - 2012
We are not associated with nor employed by Microsoft in any way, we simply provide resources!
All MS office icons are registered trademarks of the application they represent and are used with permission from Microsoft
UA-8135493-1