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

view full version: back to formated view

3501: Getting Worksheet_Change to Ignore First Row
3502: Highlight row any random color using same random color with duplic
3503: Setting a spreadsheet to auto sort data entry
3504: Auto select rows
3505: For...Next not copying text from Worksheet to Worksheet, but no Er
3506: Ranges and Number Combinations
3507: Ongoing Issue - I have tried to clarify so that you understand
3508: Strip 2 Numbers from a Hyphenated Range
3509: =?Utf-8?Q?Sections_of_Excel_2003_pivot_=E2=80=9Cbl?=
3510: combining worksheets
3511: Autofilter icons shifted to top row in Excel 2007
3512: Problem Setting Worksheet
3513: =?Utf-8?Q?1004_Error_in_VBA_Conditional_Fo?=
3514: How to Populate an Array with a Discontiguous Values
3515: VisibleRange references
3516: Adding the next month to a daily volume tracking sheet.
3517: Probably a rather basic question....
3518: Textbox problem in Userform
3519: changing date format
3520: does the "Range"object in excel2007 vba still have 65k row limit?
3521: Active chart screen visible coordinates
3522: Loop through sheets and get number of records per sheet
3523: Writing a VBA program
3524: remote references and external link values
3525: Help Loop question
3526: How can I automatically split values over specified time periods?
3527: select range
3528: Displaying Data in Matrix
3529: Combine two workbooks into one
3530: Creating a custom toolbar add-in in Excel 2007
3531: Workbook_SheetCalculate twice
3532: Make Sheets.(Range 1) = Sheets.(Range 2)
3533: DB2 timestamp format
3534: Options for error output in custom Excel functions
3535: Counting colored cells
3536: Loop through sheets & filter main sheet using sheet name
3537: Determine which variable was used in a calculation.
3538: Data check
3539: Count difference in days input box
3540: Closing a recordset error : Operation is not allowed when...is clo
3541: For To / Next loop doesn't update...
3542: Macro for popup window " update values"
3543: help with chart script and data labels
3544: =?windows-1252?Q?Using_SendKeys_to_=91activate=92_a_tab_on_2007_Ribbo?=
3545: Get templates files and copy data to it
3546: RowNumber corrupts formatting of Querytable
3547: Help to create worksheets from a list
3548: Matching cells (Excel 2007)
3549: Invisible sheets
3550: Using Data>Validation cell formatting to drive OnEntry/Intersect m
3551: VBA equiv. of Ctrl-Home w/Freeze Panes?
3552: Autoshapes on Excel user forms
3553: VBA, Search!!!! Help
3554: File on taskbar
3555: Error handling error # 1004 Run-time error
3556: Catch name of range
3557: VLOOKUP with two Workbooks
3558: Delete all object
3559: Conditional Formating
3560: VBA Sumif *********************** Help
3561: Check if data is inputed.
3562: "Workbooks.Open" fails with 2007??
3563: Code Needed for to check data input
3564: sort entire range with exception of last row
3565: VBA Time comparison not correct
3566: Looping
3567: Workbook Reopens After Close
3568: cell color change with click and record the the time and date
3569: Can't Click Anything
3570: How to calculate a Max / min in a matrix
3571: adjustine the range of a selected cell
3572: Comma replacement
3573: Excel crashes when I add VBA code programatically
3574: missing modules in personal.xls
3575: Conditional deleting of rows
3576: Problem with code - Help needed please
3577: Const and VBA values
3578: matching multiple columns on different worksheets
3579: Macro to Hide blank rows
3580: Forms TextBox Vertical Scrollbar
3581: setting delimiters
3582: Error Cell "#N/A"
3583: Combobox Error message in UserForm
3584: Center text in a shape textframe
3585: how do i separate addresses and place results in another cell
3586: Advice on code
3587: cells function
3588: find & replace
3589: Anyway to detect a new page
3590: Macro to copy and paste to another sheet, based on if-then-else
3591: Bind Event Prior to Print Preview
3592: how to declare a public workbook?
3593: Force CommandBar Position
3594: Check if file exists
3595: Remove Validation Input Messages
3596: Sql probleme on emty cell
3597: UserForm specs
3598: Print preview / full screen view problem
3599: always on top
3600: Sheets() and Window() Objects not working?
3601: how to add up string or text together
3602: Select one checkbox to Deselect another
3603: Vlookup
3604: error - select method failed - (columns.select)
3605: dsofile.dll changes lastsaved of non office files
3606: Importing data.
3607: VB for scatter graph help
3608: Auto Open macro go to beginning of week
3609: Inserting 3 blanco rows
3610: ParamArray passed multiple times in nested procedures.
3611: comparing two excel sheet and providing the outcome in a 3rd sheet
3612: comparing two excel sheets & showing matched data in 3rd sheet
3613: Using SetFocus with Frames
3614: Referencing the worksheet name in an excel function
3615: Programatically adding code to a worksheet
3616: social security number problem
3617: VB and Word
3618: Find, copy then paste problem
3619: Combine two Codes into one Sheet
3620: Clearing Duplicate Entries
3621: Click event sort ascending then descending
3622: Combobox_change event fires when a workbooks is saved
3623: Crystal Reports Newsgroup
3624: Mail merge macro: select recipients from Excel during merge
3625: Excel 2007 to SQL Server???
3626: Subtotal
3627: How to code a macro to sort a list of string?
3628: Replace string
3629: Urgent... Getting error in accessing named ranges in excel 2007...
3630: Create Pie Chart with Percentage and Show it on Userform
3631: Need help Finding row number of the last row with data.
3632: Just type the particular word
3633: Macro to generate worksheets
3634: pivotitems updating pivottable.... help!!!
3635: Find and display only duplicates
3636: Protect View Code?
3637: Excel export Issue
3638: InputBox positioning
3639: Compare cell and msg
3640: Date Formatting Within A Combo Box On A Userform
3641: duplicate vb projects occur when reopening a sheet
3642: Change enter key direction based on range
3643: Getting Path Of .XLS?
3644: .NumberFormat not getting applied?
3645: Hyperlink Base.
3646: Active sort / Copy
3647: Opening .XLS In VBA: Getting "Do You Want To Save..." Prompt...
3648: Problem where end time is less than start time
3649: changing properties of offset cells
3650: Running macro on multiple files
3651: Excel
3652: Web Query
3653: Adding values stored at relative cell references
3654: PivotTable
3655: A cell is in which named range?
3656: PROGRESS BAR QUESTION
3657: Get usable height with UserForm.InsideHeight.
3658: launching an external application within excel using contents of c
3659: How to bottom-align a control on a UserForm?
3660: formula error
3661: Query to look in default directory
3662: StatusBar not updating after Shell call and wait
3663: test
3664: Referencing cells online
3665: find a designated value in all workbooks in a designated folder
3666: TreeView node is Selected but grayed out--how set focus?
3667: Navigating Indentured BOMs (Parts Lists) in Excel
3668: Arrange Icons on Taskbar
3669: Excel 2007 VSTO 3.0 Intranet deployment issue.
3670: Excel does not get the FOCUS
3671: OnChange event attached to tick box
3672: Excel Medical Template Help Needed
3673: Excel Medical Template Help Needed
3674: object library or invalid reference
3675: Max of a range help
3676: how do I display the greater of 2 values in excel
3677: Position of MsgBox
3678: Handling Print Preview Event
3679: Range of Cells
3680: Problem using Interop.Excel in a web service
3681: Splitting up one's highlighted selection as if you had used to
3682: Excel limits
3683: Convert text file into columns
3684: COUNTIF and programming
3685: move.worksheet command
3686: auto row insert where TRUE in column A
3687: Error 1004 - PasteSpecial failure
3688: Open TXT file
3689: Force starting value for X axis?
3690: Macro disable message
3691: need help modifying ron de bruin email macro
3692: SELECT CELL AND SEND THAT INFO TO ANOTHER CELL
3693: auto line inserts needed
3694: How do I enter data on one worksheet and have it appear on another
3695: Turn on reference within a macro
3696: Include cell text in MsgBox ??
3697: Opening a file whose name is continuously changing
3698: Macro available to multiple users via network
3699: Macro Programming problems
3700: variant array with formula strings to range formulae
3701: HLOOKUPs returning an NA value
3702: Fill cell values on Interiorcolor conditions
3703: Select the Add-Ins Ribbon tab using VBA
3704: Excel to notify date of birth
3705: Dragging form
3706: Trouble with "Create separate sheet for each horizontal PageBreak"
3707: Number of cells in merged cell
3708: for loop with step increment of 0.1
3709: Error 1004 on long For loop, adding hyperlinks. What's going on?
3710: Buttons Object
3711: How do I retrieve a specific record into excel from an external db
3712: help needed! excel formulas above my head!
3713: Start value listbox
3714: Temporarily pause macro so that changes can be made on a workbook
3715: Startup Tab
3716: Change font to Italic
3717: General ODBC error AS400
3718: Executing macros in different programs
3719: Copy in a range
3720: VBA HELP! MsgBox & File & Sumif ******
3721: WinAPI Resources
3722: Button Text Problem
3723: Object variable or With Block variable not set
3724: DLL calls from Excel VBA in Vista
3725: vba calendar
3726: ShellExecute
3727: Find row referenced by a formula
3728: Help - simple but doesn't work.
3729: Move a single combo box from one cell to another...
3730: Another Conditional Formating. NEED ANSWER TO FINISH PROJECT!
3731: Cell Entry Dependent on Option Control
3732: How to have another worksheet do the calculations
3733: Need to fill a column if the column next to it is not blank
3734: Email worksheet with outlook 2003
3735: Excel sample with ADO / SQL
3736: trouble shoot Selection.AutoFill Destination
3737: Conditional Formating
3738: Subtotals + Autofilter
3739: Custom Macro
3740: Paste Excel2003 to Word2003
3741: macro to copy rows and paste-special to another workbook
3742: Control not added to "Object/Plot" command bar in Excel 2007
3743: Formula Help Needed (Sum and If Then)
3744: Macro code to dll and vba code trouble shoot.
3745: Automatically resize a cell
3746: Multiple Product selector
3747: Stop Symantec AV from quarantine my VBA
3748: VBS for excel named ranges
3749: How to know if an external link is working
3750: help with code
3751: Update links only if file exists
3752: Automatic Updating of Changing filenames
3753: Creating formula to bring back a value.
3754: Macro to copy and paste
3755: I need a "0" when cell is empty
3756: Need to open HTML Document
3757: open HTML document as text file
3758: select column
3759: Fix charts as embedded pictures
3760: Separating Commas in an Excel field
3761: Help on mail
3762: Calculation slowdown at the bottom of worksheet
3763: importing data by assigned ID
3764: vba comment box
3765: Listing months between two dates
3766: unexpected text change on pivot table
3767: Change the default style to a comment
3768: data validation trouble
3769: Adding up Time in a text box on a userform
3770: slow code execution
3771: Easy text formulae
3772: Give array values
3773: Select range
3774: Autofilter (on/off)
3775: Calling User-Defined Functions from a macro
3776: Multiply numbers in workbook by (-1)
3777: ****** Advance filter + Colouring using VBA ****** HELP!!!!!
3778: Press F2 with vba
3779: PageSetup is very slow
3780: Disabling Text Boxes without Greying them out?
3781: VBA Code - if file doesnt exist move to next file
3782: Unexpected result from IF statement... Help with formula.
3783: Paste Special to New Cells - White Page layout to Database Table
3784: Refresh web query thro macro only
3785: winzip - rondebruin's instructions
3786: New to VBA - Please help!
3787: Replace Function in Excel 97
3788: How to find text within a range of values?
3789: How is Worksheet_SelectionChange Work Different From Worksheet_Change?
3790: Improve Excel Charting
3791: Code to create a list of records in another sheet, based on the entry
3792: QueryTable Refresh Failed
3793: xlDialogColorPalette argument
3794: Listing months between two dates
3795: Creating charts in Excel 2007 through VBA. Any examples/tutorials
3796: auto add to list
3797: SQL Delete Record using Excel VBA
3798: Macro needed for billing purposes -- any general code ideas ?
3799: Complex allocation of workdays within Gov. fiscal year
3800: How to get values for Range.Validation dropdown from a second work
3801: Need Formula to Calculate Time/Overtime (2)
3802: Copy a row of data from ne worksheet to another
3803: Change Web Page Drop-Down To Fire Code
3804: Time sensitive please help!
3805: Runtime errors relating to unreleased references?
3806: Concatenate columns, variable number of rows
3807: Help ... what wrong with this code
3808: test
3809: Help ... what wrong with this code
3810: Can I graph an auto updating cell
3811: Help with VB Script
3812: Exit event/textbox/frame
3813: open HTML document as text file
3814: exporting data to the middle of a text file
3815: code to SAVE
3816: e-mail using addresses in Excel
3817: web query tables destination
3818: Excel VBA UDF Math Expressions
3819: Macro to copy and paste
3820: vba comment box
3821: prevent carrige return from being pasted
3822: GetOpenFilename
3823: XL2002 - Sort xlAscedending / xlDescending
3824: copy data from one sheet to another
3825: VALIDATION FUNCTION HELP
3826: active cell range
3827: reposition combo box **
3828: Creating an Auto Sort Indicator
3829: Random
3830: Saving an XML file to a sharepoint location using VBA in excel
3831: Setting up the same Ranges on Multiple Tabs
3832: Excel Access Violation
3833: Macro to Hide Rows
3834: 2007 is coming - what will happen to my macros?
3835: Macro to merge and format selected cell
3836: Strange Range Behavior
3837: Combobox.value reference
3838: Change a Variable Name in a For...Loop
3839: efficient code to copy/paste
3840: Macro don't run when workbook copied to new machine
3841: Sheets Loops error
3842: Async UDF
3843: Excel/Outlook Email Notifications
3844: can .range return a 1D array?
3845: Check a collection for objects that may or may not exist within it
3846: Re:Closing an excel file without saving it.(look through the code ple)
3847: SQL String
3848: Totally confused about forms + macro
3849: What Shape was Clicked ?
3850: Nested VLOOKUP in IF statement