Excel Macro

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel Misc
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - What's the difference between excel 2003 and 2005? Tag: Excel Macro Tag: 802030
  - 2
    - Random Selection I have my 30 students listed in a spreadsheet, I would like to find a way in excel that I can set up a formula that will randomly pair them up in groups of 2. I have them listed like the example below 1 Person A 2 Person B 3 Person C etc. I would like the result of the formula to random pair up the students. Tag: Excel Macro Tag: 802028
  - 3
    - Pivot Table If I have a large database that starts with 1/1/2005, I have a pivot table set up that shows an Assigned Detective, and the total of Offenses he has assigned. This works where I can select the det from the drop down and it automatically gives the total of each offense that he was assigned. Agg Assault 10, Burglary 15, etc. Is there a way I can do this for 2005, and then one for 2006, 2007 and 2008. I need a total for each year by itself. The problem is that this is a worksheet we keep adding to with each line depending on the date. One I have to copy 2005 to a sheet and then 2006, etc? Tag: Excel Macro Tag: 802027
  - 4
    - How do I copy a worksheet in the new Excel? I am trying to copy a worksheet and keep it in the same workbook. I have a set of directions from Microsoft but don't know where the Before List sheet is. I also can't seem to find the Move or copy dialog box. Any suggesstions for this luddite? Tag: Excel Macro Tag: 802017
  - 5
    - Macro To Run Automatically For Any Worksheet Upon Opening Of THe F Hello! Have recorded a macro in person.xls that basically Auto fits the cells to show the full name of each column. Have called it Auto_Open and it should open automatically for any Excel file. The need is as follows. The user team team will double click on a csv file and they have associated csv file types with Excel, would like this macro to run for them and the questions follow. 1) First, prior to distributing the macro to other users, would like to make sure it works but having an issue getting it to Auto Open when any csv file is double clicked, the macro is not running, what might be missing here. Have to go to Tools - Macro - Macros, select Auto_Open and then run it, the macro is not running automatically when the csv file is opened, had assumed that calling it Auto_Open would do this. Currently working with Excel 2003 version. 2) How is the macro, Auto_Open, which was created locally, distributed to other users - possibly share it from a network location or send it to each member of the user team 3) How does a user install the macro so it works for them for any Excel file Have looked at some of the other reponses to similar topics in this forum but not totally understanding it yet. Would appreciate any help. Thanks! Tag: Excel Macro Tag: 802015
  - 6
    - Formula to return column letters In Excel 2007, I need to use the letters of the column that I am in in the formula bar. However, I don't need a particular cell, just the letters. Because of this, the letters do not change as I use Autofill down the row. I am using over 500 columns, so I really need for Autofill to do this for me. Basically, in the formula bar, I have "A" in part of my formula (when I am in column A), but when I autofill, every column still has "A" rather than updating. Is there a formula that returns the column letters of the current position? Tag: Excel Macro Tag: 802012
  - 7
    - How can I hide a formula in Excel 2007 from other users seeing it I'm creating a spreadsheet for other users to enter data in and one of the cells has a formula that I don't want them to see. I've got it to where I can hide it on the first row but when I tab down to the next row it won't let me enter any data. Is there a way to hide the formula in that column without messing up the rest? Tag: Excel Macro Tag: 802010
  - 8
    - Refer to adjacent cells as variables in formula In a large column of data some cells randomly have entries of "no data"- (caused by a comms failure at that time). I'd like to interpolate data for these cells by filling them with actual values in cells either above or below them. Can I create a formula that refers to cells either immediately above or below the cells? My problem is that I don't know how to refer to a cell as 'the cell above this one' or 'the cell below this one', as a variable instead of as a specific cell location. If I do find out how to refer to cells like this I suppose that I'll have to make the full formula an 'If' statement- the logic being: "If cell xx ="No Data" then cellxx = cell above cellxx" Thanks very much for any help, Dominic Excel version: Office 2000 Tag: Excel Macro Tag: 802008
  - 9
    - Save as CSV results in an Excel file!? Windows XP, Excel 2003 I have a user who I am helping remotely. They have a small Excel file - about 12 rows. They do a Save As and select "CSV (comma delimited) (*.csv)" as the file type, then click Save. Oddly, they do not receive the usual warning about "features not compatible...", however the file is saved and appears to be a CSV file with the appropriate extension. When this file is opened in Notepad to check it out, it clearly is *not* a CSV file - all special characters and gobbledegook. In fact, the contents look just like a standard Excel file (XLS). I cannot reproduce this odd outcome on my own system. When I save as a CSV, I get the expected warning and the resulting file looks like a CSV file in my text editor. Is there some setting or option in Excel that would cause this behavior? Something that would save the file as an Excel file even when the "save as file type" is set to CSV? -- TRW _______________________________________ t i m . w i t o r t _______________________________________ Tag: Excel Macro Tag: 802000
  - 10
    - East Asian characters in Excel 2003 worksheet do not print. I have an Excel 2003 worksheet that contains East Asian (Simplified Chinese) characters. Although these characters appear in print preview, they do not print on any of my printers -- only the English characters print. However, the Chinese characters print from Word 2003 documents and from PDFs of the Excel worksheet. My operating system is Win XP Pro. I have installed the files for East Asian Language support. What am I missing? Thank you in advance for your help. Tag: Excel Macro Tag: 801998
  - 11
    - Workbook won't allow me to insert worksheet. How can I add one? Hey. I have a workbook given to me by someone and when I try to insert additional workseets to the workbook it won't let me. The "insert" function is not available when I try to add a new sheet. Any sugestions on how to allow the workbook to let me insert new worksheets? Thanks. Tag: Excel Macro Tag: 801997
  - 12
    - questionnaire template I need a template for the following: Type: Online questionnaire for clients Format: Questions are a mix of Yes/No or multiple choice (some with more than one answer selected from a list) Output: All answers carry a weighting and total points are shown on a sidebar as the client completes the questionnaire The points per question are derived from a control benchmark database (not visible to the client) -- KAS Tag: Excel Macro Tag: 801990
  - 13
    - How do I put a checkbox with no words? I am making a chart with names down the left column and other catagories along the top. I want to put checkboxes in so people can just check them individually for their cell in that catagory. I am wondering how to put the checkbox in without any words. (such as "checkbox 1") I want to remove the words. Tag: Excel Macro Tag: 801989
  - 14
    - Data Fields in Pivot Table I'm trying to write a macro that will clear all fields in my pivot table including the data fields. I have the following: On Error Resume Next Dim pt As PivotTable Dim pf As PivotField Sheets(4).PivotTables("PivotTable2").ClearAllFilters Set pt = Sheets(4).PivotTables(2) With pt For Each pf In .VisibleFields pf.Orientation = xlHidden Next pf End With The macro above clears all fields except the data fields. Any ideas for what I could add to the macro to make it also clear the data fields? Thanks. Tag: Excel Macro Tag: 801982
  - 15
    - Page numbers appearing across spreadsheet There are large page numbers ie. PAGE 1, PAGE 2 appearing across my spreadsheet - they don't appear on the print out, only on the screen. How do I make them go away? Tag: Excel Macro Tag: 801981
  - 16
    - Macro to Fit AutoShape over Range? It seems to me that inserting and manipulating AutoShapes is incredibly straightforward in Excel, but users of a form in our office have asked if there's a way to more quickly make rectangles that would EXACTLY cover whatever range of cells they have selected. (This is all the more annoying of a request, because most of the users are on Excel for Mac, whose Formatting Palette makes this sort of thing even easier.) Anyway: can a macro be written that will do this? I'm imagining that, after a user left-clicks and drags through any area, that they'll right-click, select the macro from the shortcut menu, and the code will plop a rectangle over the area. (I already have a number of custom options on the shortcut menu, so that I can do that part myself.) I know this is all absurd, but any help anyone can offer would be much appreciated! Tag: Excel Macro Tag: 801978
  - 17
    - Default Save Extension Posted in another excel newsgroup 7/11/08 but no solution: I'm using Office Home and Student 2007 on a Vista Home Premium machine. I'm unable to change the default save extension from xlsx to xls. I can do it on an individual file by file basis but I would like to have the program always save the files to a default extension of xls. I've changed the setting in Excel Options and the setting "sticks" but the program continues to create and save as xlsx. I also have the same problem in Word. Any help is much appreciated! Thanks in advance. Tag: Excel Macro Tag: 801976
  - 18
    - Error message - Errors were detected while saving FILENAME In Excel 2007, when saving a file, we get the following message... "Errors were detected while saving FILENAME. Excel may be able to save the file by removing or repairing some features" If we click continue, it gives us the file selection screen to "save as" Press enter, and we get "The file already exists. Do you want to replace the existing file?" If click "yes", the next message is "No errors were detected in FILENAME. No repairs were necessary" Click OK and it saves the file. I have searched newsgroups, but only find references to TrendMicro AV or MS Livecare possibly causing the problem; neither of which we have. Any help would be appreciated. Tag: Excel Macro Tag: 801970
  - 19
    - Cells not included in formulas I have a summary page that pulls numbers in based on account numbers from a detail spreadsheet. Column A is the account number, Column B is the amount on the detail spreadsheet. Is it possible to do some sort of trace function to see what numbers are not going into the summary worksheet? I haven't had this error before and there is not one amount that comes close to matching the difference from the summary sheet to the detail sheet. Hope this makes sense. Tag: Excel Macro Tag: 801969
  - 20
    - Database problem I have set up a spread sheet to keep a track of my spending. Column A is formatted to dd/mm/yyyy and columns B, C, D, E, & F are my expenses with column G being income and column H being the balance. I am trying to set up a seperate worksheet where a single cell will give me the total spending based upon a calendar month. Many thanks in advance for all those who have helped. Tag: Excel Macro Tag: 801968
  - 21
    - excel spreadsheet compare I looking for something I could utilize that would compare two excel spreadsheets. It would need to compare across all cells and note any changes. There will be text and numbers contained within the cells. I've seen some stuff posted on here, but it compares (I.E cell A1 to cell A1). The excel spreadsheets I'll be reviewing will have adds, updates and deletes. So it needs to compare based on a unique identifier (probably name in first column) and then note if there are any changes. Also, note if the data between the two excel spreadsheets is new or deleted data. thanks for any help you can provide.. Tag: Excel Macro Tag: 801965
  - 22
    - Exporting Quickbooks Data into Excel When I run a report and export it into Excel, the file size is way larger than it should be. It seems like when the file gets imported into Excel, there are thousands of extra lines that don't contain any data. I end up having to copy and paste the data into a new Excel spreadsheet. Does anyone know how to fix this problem? Tag: Excel Macro Tag: 801962
  - 23
    - Form a sublist from a list using lookup I have a table listed as follows: (A) (B) (C) 1) Name Region Age 2) John America 23 3) Lee Asia 42 4) Johann Europe 18 5) Tom America 43 6) Sara America 19 7) Ricardo Europe 37 I am trying to form 3 new additional tables for each of the three regions from this table that lists only Names of people over 30 yrs old (preferrably in a descending order). I thought of using something like =IF(AND(C2>30,B2="America"),A2,""), but instead of "", I would want the formula to look into the next rows until it finds one that fits the region, or if it finds none - then it should leave a blank cell. Otherwise, each of the tables would have many blank rows within, between the rows that are of interest. Any ideas of how this could be accomplished? Thank you very much in advance! Tag: Excel Macro Tag: 801955
  - 24
    - Formatting text within merged cell I am trying to enter a row of data in a cell that does not completly fill the cell and want to hit enter to enter more underneath without jumping to the next cell. Tag: Excel Macro Tag: 801949
  - 25
    - Unprotect workbook Using Excel 2007, how do you unprotect the workbook in an Excel 2003 file. The protect workbook function actually indicates it is not protected, but I know it is. Also, when I try to copy in a new worksheet, it says it is protected. Please help. Tag: Excel Macro Tag: 801948
- Next
  - 1
    - Commas drop off of number in mail merge to into Word Does anyone know why when I mail merge using Excel 2007 into Word why the commas drop off of the numbers shown in my columns? Tag: Excel Macro Tag: 801941
  - 2
    - Dating a file. What can I add to a file, that I send out periodically, to date stamp that version of the file? -- Matt S Tag: Excel Macro Tag: 801940
  - 3
    - Protecting Cells from changing or modifying long formulas How do I protect certain cells from being changed by other users because i have a long formula within the cell? The rest of the cell in the spreadsheet they can modify, except those particular cells. Tag: Excel Macro Tag: 801934
  - 4
    - Why does my cell content display as '############'? when typing text into a cell, the cell will display '#######' instead of the actual text I've typed. re-sizing the row/column does not help. Tag: Excel Macro Tag: 801920
  - 5
    - Sorting by name but ignore the word The I have a list of movies and I want to sort them by name then what stack there in. a b Gone with the wind | stack 7 The god's must be crazy | stack 6 Except I want to ignore the word "the" in the title but still have it in the title after the list is sorted alphabetically. Easy to do? Is there a way to hide the word and it will sort OK ? Thanks for any help, Rich Tag: Excel Macro Tag: 801919
  - 6
    - Displaying BOTH formulas and values Is there some easy way to display both the values and the formulas? I want to be able to show the results of the formulas as well as the formulas used in obtaining the cell results. I know I can toggle back and forth by using Ctrl+`, but for what I want to do I now have to display the formulas and copy the sheet as formulas into a new worksheet, then insert columns and copy over the results into adjacent columns of cells. Is there another way of doing this? Tag: Excel Macro Tag: 801913
  - 7
    - Timestamp for changes in any row of cells? Hi, I am trying to set up a timestamp at the end of a row of cells that will enter the current date if any cell in the row is altered or updated. I can only do it at present with one cell, if I use a range of cells the formula doesn't work, not sure why. The formula I use is =IF(R4="","",IF(T4="",NOW(),T4)) If I change the R4 to A4:R4 I get a wrong #Value. I'm running Office Pro Excel 2003 edition with SP3. Thanks for any help. Tag: Excel Macro Tag: 801910
  - 8
    - Place zeros in blank cells I have set up an Excel spreadsheet that will be used to input a variety of data that will be imported into an Access database. The data is all numbers and the reports that I run in Access can't do the calculations on blank cells. There are usually 1500 records that are being imported and there are 9 columns that contain numbers, but not all will have a number entered. What I need to find out is how to setup this spreadsheet to automatically place a zero in all blank cells prior to importing without doing it manually. The last time I did it, it took me about 20 minutes. Tag: Excel Macro Tag: 801908
  - 9
    - Cells won't automatically update --- urgent! Hello, We are having a problem with one of our excel templates at work, and we are on a tight deadline. The workbook is quite large....probably 50 to 80 sheets or so. Most of these sheets have been duplicated off of other sheets. The issue is that we have a bunch of valuation multiples linked to an assumptions page, and when we change the number on the assumptions page, the multiples do not update through out the template. We have tried a number of things. We have verified that the cells are set to automatic update in the options menu. We have also tried to go into a worksheet select all and hit F9, which you would think would update the cells. I have also, click on the specific that i want to update and hit F9, and nothing happens. The only way I can get the cell to update is if i put my cursor inside the cell, and hit enter. There is no way that I can go through every individual cell and update them manually like this. Plus we would not be too confident in the integrity of our template. I would consider myself a fairly advance user of excel, and I am quite familiar with using macros in visual basic. If anyone has an easy solution or a set of code that I can run that will update the template for me that would be much appreciated. Thanks in advance!! Ryan Tag: Excel Macro Tag: 801906
  - 10
    - Count I have a large spreadsheet dating back from 2006, is there a way I can search by a Detectives Name which is in Col K and then count the assigned offenses in Col G, example: Detective John Brown col k and then search col G, AA (Agg Assault) and give me a total for Agg Assault, then change col G for Burg (Burglary) and give me a total for Burglary, etc. I have been counting by doing a filter, but I felt there could be an easier way. Thanks, Tag: Excel Macro Tag: 801904
  - 11
    - Print Landscape/Portrait based on level of grouped data selected Probably not possible....but I have a spreadsheet I send to multiple clients where the rows are grouped on levels 1-5 (5 being the most specific of the data, therefore most rows). I have set up buttons (macro assigned) which they can use to print just their columns of data. The titles to the left of the data are repeating, so each individual macro is simply selecting the appropriate columns, setting print area, and printing. I find that levels 1, 2 & 3 of data look best when printed in Landscape. Levels 4 & 5 look best when printed in Portrait. Is there something that I can add to a Macro in order for it to print Portrait/Landscape based on the level of grouped rows selected? Thanks! Tag: Excel Macro Tag: 801902
  - 12
    - Integrity of Column Headers I have created a company form in Excel. The form has several columns and each column has a one, two or three line column header. The form was designed to be viewed at 100% Zoom (the viewing tool in the Standard toolbar). Apparently some form users are viewing the form at 50% or 75%. When viewed at less than 100%, the lines in the column headers break in odd places, for example, when the view is reduced, the one-line header "Quantity" breaks into two lines: Quantit y and the two-line header "Catalog Page No." breaks into three lines: Catalo g Page No. Other than increasing the size of the cells the column headers are in, is there a way to freeze the headers so this odd line breaking won't happen? I tried un-selecting "Wrap Text" in the Format Cells/ Alignment/Text Control menu and this made the headers be one line and the entire header wouldn't display in the header cell, so that wasn't the answer I'm looking for. Can someone help, please? Thank you for your help with my question. Leslie Tag: Excel Macro Tag: 801900
  - 13
    - Rotating on-call schedule M-F for 13 people? How can I create an on-call schedule for lunch time coverage that changes by person (13) everyday? Is there a way to do it in an Outlook Calendar? These people also have days that they can not take call due to a prior committment. Tag: Excel Macro Tag: 801892
  - 14
    - I am unable to unhide rows through the format menu. I have tried unhiding rows and my worksheet is not protected and the panes are not frozen. I have also tried selecting the entire worksheet to unhide, but I wasn't able to see all of my hidden rows. Tag: Excel Macro Tag: 801889
  - 15
    - HOW DO I CREATE A SERIES INVOLVING CELLS ACROSS ROWS? I'm trying to fill cells across a row. The first cell references C18, the next F18, the one after that I18 and so on i.e two cell are to be skipped to get to the next value I want. However, after i fill the first 3 values manually and drag the fill handle after selecting all three the next value to be filled in is F18, then I18, L18, I18 and so on. Is there a way to make the fill follow the series I want it to? The problem persists even if I fill 5 cell manually. Tag: Excel Macro Tag: 801886
  - 16
    - Preserved cell formatting We have an excell workbook that is linked to an extrenal SQL data source. The preserve cell formatting box is checked on the External Data Range Properties pop up. Randomly we will get cells were the format is being changed. The data fields that are being imported are text. The cell format is set to General and is being switched to Text. When this happenes the cell display all #######. I have been checking the data in the cells that this happens too for any odd charicters. (line feeds, char returns....) I don't see anything that would make this happen. It looks to be completly random. Any insight would be a huge help. Thanks Kevin Tag: Excel Macro Tag: 801885
  - 17
    - Need to find the name of the command buttons I inherited a spreadsheet that contains 11 steps kicked off by command buttons. I want the command buttons to be disabled as they are completed so the users will not run the same process more than once. I'm not able to find the names of the buttons to be able to reference them. Tag: Excel Macro Tag: 801884
  - 18
    - splitting my cell hey all i have a cell like the following: 1|2 can someone please show me how to put the 1 and the 2 in 2 separate columns? thanks, rodchar Tag: Excel Macro Tag: 801879
  - 19
    - List Dependent Worksheet Functions I am creating a summarising worksheet that evaluates a list of numbers. The list of numbers is held in a column of adjacent cells called 'ListVal1'. I wish to evaluate the numeric cells in 5 possible ways as determined by the user - the analysis could be any one of SUM, AVERAGE, MIN, MAX or COUNT. The user selects the analytical process by reference to a text value in a related cell - in this case cell 'B11'. The following formula works but is both cumbersome and has reached the limit of nested 'if statements' =IF(B11="","",IF(B11="SUM",SUM(ListVal1),IF(B11="AVERAGE",AVERAGE(ListVal1),IF(B11="MAX",MAX(ListVal1),IF(B11="MIN",MIN(ListVal1),IF(B11="COUNT",COUNT(ListVal1),"")))))) Does any one have a more flexible (less cumbersome) approach? Tag: Excel Macro Tag: 801878
  - 20
    - LIST BOXES TOO WIDE I created several drop down list boxes to limit entries in several fields in a worksheet. Two fields are limited to "YES" and "NO." When I click on the down arrow which makes the list pop up, it is a good 3-4" wide, with the YES and NO at the far left of the box. It is quite annoying to have to move the mouse so far to click the appropriate choice. Is there some way to limit the width of the drop down box? Thanks for ideas. -- William Tag: Excel Macro Tag: 801874
  - 21
    - Date value conditional formatting or Macro Hello The cell value is 00Y - 07M which is a date formatted as yy "Y" - mm "M". This column has over 1,000 numbers. What I want to do is if the first three values = E.g. 00Y - 07M then show only the last values or 07M otherwise it should remain the same Thanks Tag: Excel Macro Tag: 801871
  - 22
    - Multiple "IF" I'm sorry I didn't make it clear what I needed. E2 E3 61 E3 needs to be the total of E2. The numbers 0-3=0, 4-10 * 2.43, 11-61*1.75. 4-10 would equal 17.01 and 11-61 would equal 89.25 and the total should be 106.26. Any help would be greatly appreciated. -- LindaM Tag: Excel Macro Tag: 801870
  - 23
    - Import/export netCDF files to Excel Is there any way to import and/or export data files in net CDF format in Excel 2003? Tag: Excel Macro Tag: 801843
  - 24
    - Multiple "If" I am trying to write a formula that will multiple the numbers between 4 and 10 by $2.43 and add that to the numbers between 11 and 100 that is multiplied by $1.75. Example: A1 = 61 and the total in B1 would be 4 thru 10 multilplied by 2.43 and then added to 11 thru 61 that has been multiplied by 1.75 -- LindaM Tag: Excel Macro Tag: 801838
  - 25
    - Creating a Macro? V2 I don't know how to reply to a post and get it to come back to the top of the list so I am starting a new thread under the same heading. Sorry everyone. Pete and Gord responded to my original thread but unfortunately I was not able to get their advice to work. My original question related to a four page survey. The survey is posted on our intranet at work for people exiting our employment. Once they have completed the survey they activate the submit button returning the survey to our HR people. The survey contains four pages (worksheets) with the submit button on the last page (page four). When the submit button is activated it emails the workbook. When the recipients opens the workbook it opens at page four because that was the last page open and the one with the submit button on it. I want the macro to basically return the workbook to page one when the submit button is activated so that when the recipients open the workbook they see page one first and not page four. The VBE I am using is below and is one of Debraâ??s (I just wish I knew how to write this stuff, but I am learning a little bit, obviously not enough though) Sub Mail_workbook_1() Dim wb As Workbook Set wb = ActiveWorkbook If Val(Application.Version) >= 12 Then If wb.FileFormat = 51 And wb.HasVBProject = True Then MsgBox "There is VBA code in this xlsx file, there will be no VBA code in the file you send." & vbNewLine & _ "Save the file first as xlsm and then try the macro again.", vbInformation Exit Sub End If End If On Error Resume Next wb.SendMail Array("email.address"), _ "Exit Survey" On Error GoTo 0 End Sub Sorry this is so long. Cheers Tag: Excel Macro Tag: 801835

Can anyone tell me the macro language to instruct the cursor to move over x
number of cells?
--
RCB

RE: Excel Macro by FSt1

FSt1
Tue Jul 22 14:41:02 CDT 2008

hi
activecell.offset(0,x).select

the offset number are offset(row,column)
row - negative numbers = left
positive numbers = right
column = negative numbers = up
positive numbers = down

regards
FSt1

"RCB" wrote:

> Can anyone tell me the macro language to instruct the cursor to move over x
> number of cells?
> --
> RCB

Top

RE: Excel Macro by RCB

RCB
Wed Jul 23 08:36:00 CDT 2008

Thank you!
--
RCB

"FSt1" wrote:

> hi
> activecell.offset(0,x).select
>
> the offset number are offset(row,column)
> row - negative numbers = left
> positive numbers = right
> column = negative numbers = up
> positive numbers = down
>
> regards
> FSt1
>
>
> "RCB" wrote:
>
> > Can anyone tell me the macro language to instruct the cursor to move over x
> > number of cells?
> > --
> > RCB

Top