TheMSsForum.com >> Excel Programming >> Archive Page 10 - The Microsoft Software Forum

view full version: back to formated view

3151: Testing Blank Conditional Formatting
3152: Conditional Formatting
3153: Insert text from Comment in 3/4 TextBoxes in a Form
3154: Remove Columns with header in row 1 but no data in remainder of co
3155: Display a Line w/ Caption instead of Frame w/ Caption
3156: Manipulating Multiple Versions of Excel, c#
3157: Print Formating using VBA
3158: Select a column within a query
3159: How to avoid warning pop-up dialog boxes
3160: UDF for dynamic custom lookup?
3161: UD
3162: Excel macro to copy row from one tab to another based on certain criteria
3163: Referencing a row with a maximum value array?
3164: referencing the actual row number? How?
3165: Macro - move active cell to another column; same row
3166: How do link the prolog output to an excel sheet.
3167: How do link the prolog output to an excel sheet.
3168: Data Source, auto populate rows and columns
3169: ADO connection not opening in Excel 2003
3170: Newbie here .
3171: Pulling out numeric number from Activecell.Address
3172: Passing array elements to a function
3173: Turn display alerts off then back on at close
3174: Choosing Active Cell
3175: Fixed 'Find' or 'Look up'? cell - is it possible?
3176: Writing a Sort Macro
3177: Newbie w/question
3178: Workbook Properties
3179: How to retrace the execution path?
3180: How to knwo the current statement
3181: Copy value from formula result on event change of cell value
3182: Data
3183: using application.filesearch for searching text in PDF
3184: VBAProject Protection
3185: Conditional Formatting through VBA ODBC
3186: Avoid Prompts on Workbook open?
3187: Should I use Excel or the OWC11.spreadsheet control in a web page?
3188: Hi all,
3189: new Freeware Excel add-in for importing from ODBC data sources
3190: Protecting Sheet
3191: Delete Page Breaks -
3192: Copy paste without selecting sheet or range
3193: Open txt file without changing date
3194: Using VLookUp
3195: Excel Wscript Selection Problem
3196: Handle an "Excel cannot complete..." alert window with
3197: remove VBA codes while saving
3198: epression REPLACE
3199: username and password when login
3200: help me(indirect function error)
3201: Sticky interior colors
3202: Validations with messages in userform
3203: Macro to look up and match names?
3204: Is it possible to link an Excel Workbook with a data base?
3205: Globals Go "Poof!": Workarounds?
3206: Finding attachment point for comment textbox
3207: Excel 2007 - Format of New Documents
3208: VB Macros for Charts - Fails (Office 2003 on WInXP Sp2)
3209: Importing Microsoft Word to Excel
3210: Security settings for Excel 2003 are lost on Vista 64 bit OS
3211: Is it possible to change and entire worksheet to text?
3212: profit margin based on prices
3213: String Comparison
3214: preselecting in combo box
3215: task scheduling
3216: Help with transpose?
3217: Are you telling me all a virus has to do is run from XLSTART to
3218: IF statement
3219: Logging data to worksheet
3220: Insert a Row - Variable Location
3221: Which references will I need to reinstall on a new machine?
3222: Unprotect entire sheet
3223: Creating a macro to filter data on multiple sheets
3224: Custom menu items in a copied workbook
3225: Set Pivot Table Pages
3226: Copy and paste every x number of cells
3227: Application.FileSearch Problems
3228: If cell 'a' matches cell 'b' then copy cell 'd' to cell 'e'
3229: List all link cell to other workbooks
3230: Help with Autofill
3231: Run a Macro just after i open a workbook EXCEL
3232: referring to a textbox on a different userform.
3233: RTD Links retain previous values in certain conditions -- bug?
3234: Run Time Error 3343 - Unrecognized database format:
3235: AutoFilter Trigger Calculation
3236: Pagefield - select "(All)"
3237: Sum column values and insert result in last cell with VBA
3238: Saving w/ Stronger Encryption in Excel 2007
3239: Change in cell disabling events
3240: send email macro with Outlook running
3241: paste file name of an OFFice program into a cell
3242: last record
3243: Vacation Accrual
3244: VBA - Copy paste all Modules
3245: Excel 2007 data query parameter issue
3246: Duplicate in Row
3247: Sendmail, XL97 vs XL2k
3248: Evaluate text formula in VBA
3249: Sumproduct with Autofilter
3250: Duplicate removal macro keeps newest record
3251: Starting Outlook via FollowHyperlink event
3252: VB Help If Statement in Selection.ShowDetail = True
3253: activate code upon save command
3254: Macro not running anymore
3255: Sum all Cells with Interior Color Index not equal to 0
3256: How do I use VBA or a function to do a certain type of string work
3257: Pagebreaks vs page numbering
3258: Is there a steep learning curve for excel 2008 VBA as opposed to
3259: Problem with Worksheet_Activate event
3260: How come code written by a macro won't replay in excel 2008?
3261: Collect data from Excel files
3262: Automation error
3263: View workbook
3264: Function that groups together Overtime hours by 7.5 hrs
3265: Automatically Update Excel Graphs
3266: copy data to combobox value sheet
3267: List Problems
3268: Use VBA to display record with criteria
3269: Pivot table - sorting
3270: CommandButtons have stopped working
3271: How do I modify this macro to print the currently visible chart?
3272: Viewing hidden data
3273: Place TextBox Behind Other Controls on a Workshheet
3274: Command Button
3275: Filesearch won't clear
3276: >= Greater than or Equal to Not working
3277: Excel macro security fails in directory XLSTART.
3278: Font color in userform controls.
3279: User form- protection and password.
3280: Does a Pivot External Source to SQL Server stay connected?
3281: Open Office Outlook & Insert e-mail address
3282: override old format
3283: Formulas and Cumulative Values on a Line Chart
3284: conditional format question
3285: Problem using internetexplorer object to open a url
3286: Easier Method
3287: Difficulty with copy and paste
3288: Concatenate
3289: Date Format HELP
3290: VBA Structure Charts
3291: Adding images to cells via VB.Net
3292: How to add an array to a combo box with Excel 2003?
3293: Formatting Comments
3294: xl2007 speed issues
3295: Inserting Formula moving down each row
3296: Update Add-in
3297: Splitting cells
3298: Event Fired when Calculation Mode Changed
3299: Signature Authentication
3300: Relative links to worksheets
3301: Search and Find Missing In Action
3302: Comparing
3303: User Defined Functions to separate full names
3304: Listing Occurences of a date
3305: SharePoint Versions
3306: Selecting Shapes
3307: Adding Data Label value with VBA to a chart
3308: Error 1004 - Unable to set invertifnegative
3309: Conditional Formating
3310: Dependent Validation List
3311: Alternate row shading
3312: Is there a way to skip lines (insert value every other line)
3313: Locking Cells
3314: Processing a Message Box w/in a Macro
3315: VALIDATION FUNCTION HELP 2...
3316: import multiple CSV files into one Excel file
3317: End of Statement error
3318: Goto ("A1") in non active sheet
3319: CLEAR FIELD TEXT ON CLICK?
3320: how to access column 8 in my Range
3321: VALIDATION FUNCTION HELP
3322: Adding up range of cells exclude hide cells
3323: Excel Workbook.SaveAs xml spreadsheet gives garbage number
3324: with a macro open a workbook without the Auto_Open running
3325: Publishing a static table using jscript (Excel 2007)
3326: formula in code
3327: Color Change Syntax
3328: Delete last sheet in workbook
3329: Lookup from a list of numbers
3330: format the cell Comment
3331: Date field in user form & Loading a user form on opening workbook
3332: copy row based on match and multiple criteria
3333: 2nd TRY: Up from 2003 to 2007; code now throws error creating
3334: How do I make a cell truly empty using an "If" statement?
3335: Multiselect listbox if no selection
3336: Run-Time error '9' New Question
3337: vba - Select Used Range minus the top header
3338: Programmatically add worksheet function
3339: excel 2000 to excel 2007
3340: Procedure level array not recognised at module level
3341: Limiting access to registry
3342: 1004 Error on Workbooks.Open when run from inside IE
3343: Autocopy instead of autofill
3344: accessing Outlook Address book from Excel VBA
3345: Array function not working correctly if I use an "or - statement"
3346: Build data from Invoices.
3347: first space from the right
3348: Need worksheet Event for Sum
3349: Date Field Problem in Userform
3350: Start Word within Excel 2007
3351: VBA "Excel & Outlook" **************
3352: triggering Workbook_SheetCalculate
3353: Copy subtotal results
3354: programming issue when using Excel automation
3355: Super Hard Question
3356: Macro doesn't record action on a chart
3357: Re : Excel Chemistry Before and After
3358: Finding cells with matching data
3359: Replacing column values with formula values
3360: don't want column width change after refresh
3361: why does s.TextFrame.Characters.Text work only sometimes?
3362: PrintPreview problem in 2007
3363: Run-Time error 1004. Help Please!
3364: how do find the actual macro file on hard drive to send?
3365: Fast Way to Delete Rows from Big Spreadsheet (Using VBA)
3366: url content
3367: url content
3368: Excel file on Treo to dial phone numbers
3369: Excel 2003 Markers
3370: text in file
3371: 2007 Copy Paste Disabled
3372: Getting Worksheet_Change to Ignore First Row
3373: Highlight row any random color using same random color with duplic
3374: Setting a spreadsheet to auto sort data entry
3375: Auto select rows
3376: For...Next not copying text from Worksheet to Worksheet, but no Er
3377: Ranges and Number Combinations
3378: Ongoing Issue - I have tried to clarify so that you understand
3379: Strip 2 Numbers from a Hyphenated Range
3380: =?Utf-8?Q?Sections_of_Excel_2003_pivot_=E2=80=9Cbl?=
3381: combining worksheets
3382: Autofilter icons shifted to top row in Excel 2007
3383: Problem Setting Worksheet
3384: =?Utf-8?Q?1004_Error_in_VBA_Conditional_Fo?=
3385: How to Populate an Array with a Discontiguous Values
3386: VisibleRange references
3387: Adding the next month to a daily volume tracking sheet.
3388: Probably a rather basic question....
3389: Textbox problem in Userform
3390: changing date format
3391: does the "Range"object in excel2007 vba still have 65k row limit?
3392: Active chart screen visible coordinates
3393: Loop through sheets and get number of records per sheet
3394: Writing a VBA program
3395: remote references and external link values
3396: Help Loop question
3397: How can I automatically split values over specified time periods?
3398: select range
3399: Displaying Data in Matrix
3400: Combine two workbooks into one
3401: Creating a custom toolbar add-in in Excel 2007
3402: Workbook_SheetCalculate twice
3403: Make Sheets.(Range 1) = Sheets.(Range 2)
3404: DB2 timestamp format
3405: Options for error output in custom Excel functions
3406: Counting colored cells
3407: Loop through sheets & filter main sheet using sheet name
3408: Determine which variable was used in a calculation.
3409: Data check
3410: Count difference in days input box
3411: Closing a recordset error : Operation is not allowed when...is clo
3412: For To / Next loop doesn't update...
3413: Macro for popup window " update values"
3414: help with chart script and data labels
3415: =?windows-1252?Q?Using_SendKeys_to_=91activate=92_a_tab_on_2007_Ribbo?=
3416: Get templates files and copy data to it
3417: RowNumber corrupts formatting of Querytable
3418: Help to create worksheets from a list
3419: Matching cells (Excel 2007)
3420: Invisible sheets
3421: Using Data>Validation cell formatting to drive OnEntry/Intersect m
3422: VBA equiv. of Ctrl-Home w/Freeze Panes?
3423: Autoshapes on Excel user forms
3424: VBA, Search!!!! Help
3425: File on taskbar
3426: Error handling error # 1004 Run-time error
3427: Catch name of range
3428: VLOOKUP with two Workbooks
3429: Delete all object
3430: Conditional Formating
3431: VBA Sumif *********************** Help
3432: Check if data is inputed.
3433: "Workbooks.Open" fails with 2007??
3434: Code Needed for to check data input
3435: sort entire range with exception of last row
3436: VBA Time comparison not correct
3437: Looping
3438: Workbook Reopens After Close
3439: cell color change with click and record the the time and date
3440: Can't Click Anything
3441: How to calculate a Max / min in a matrix
3442: adjustine the range of a selected cell
3443: Comma replacement
3444: Excel crashes when I add VBA code programatically
3445: missing modules in personal.xls
3446: Conditional deleting of rows
3447: Problem with code - Help needed please
3448: Const and VBA values
3449: matching multiple columns on different worksheets
3450: Macro to Hide blank rows
3451: Forms TextBox Vertical Scrollbar
3452: setting delimiters
3453: Error Cell "#N/A"
3454: Combobox Error message in UserForm
3455: Center text in a shape textframe
3456: how do i separate addresses and place results in another cell
3457: Advice on code
3458: cells function
3459: find & replace
3460: Anyway to detect a new page
3461: Macro to copy and paste to another sheet, based on if-then-else
3462: Bind Event Prior to Print Preview
3463: how to declare a public workbook?
3464: Force CommandBar Position
3465: Check if file exists
3466: Remove Validation Input Messages
3467: Sql probleme on emty cell
3468: UserForm specs
3469: Print preview / full screen view problem
3470: always on top
3471: Sheets() and Window() Objects not working?
3472: how to add up string or text together
3473: Select one checkbox to Deselect another
3474: Vlookup
3475: error - select method failed - (columns.select)
3476: dsofile.dll changes lastsaved of non office files
3477: Importing data.
3478: VB for scatter graph help
3479: Auto Open macro go to beginning of week
3480: Inserting 3 blanco rows
3481: ParamArray passed multiple times in nested procedures.
3482: comparing two excel sheet and providing the outcome in a 3rd sheet
3483: comparing two excel sheets & showing matched data in 3rd sheet
3484: Using SetFocus with Frames
3485: Referencing the worksheet name in an excel function
3486: Programatically adding code to a worksheet
3487: social security number problem
3488: VB and Word
3489: Find, copy then paste problem
3490: Combine two Codes into one Sheet
3491: Clearing Duplicate Entries
3492: Click event sort ascending then descending
3493: Combobox_change event fires when a workbooks is saved
3494: Crystal Reports Newsgroup
3495: Mail merge macro: select recipients from Excel during merge
3496: Excel 2007 to SQL Server???
3497: Subtotal
3498: How to code a macro to sort a list of string?
3499: Replace string
3500: Urgent... Getting error in accessing named ranges in excel 2007...