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

view full version: back to formated view

6651: epression REPLACE
6652: username and password when login
6653: help me(indirect function error)
6654: Sticky interior colors
6655: Validations with messages in userform
6656: Macro to look up and match names?
6657: Is it possible to link an Excel Workbook with a data base?
6658: Globals Go "Poof!": Workarounds?
6659: Finding attachment point for comment textbox
6660: Excel 2007 - Format of New Documents
6661: VB Macros for Charts - Fails (Office 2003 on WInXP Sp2)
6662: Importing Microsoft Word to Excel
6663: Security settings for Excel 2003 are lost on Vista 64 bit OS
6664: Is it possible to change and entire worksheet to text?
6665: profit margin based on prices
6666: String Comparison
6667: preselecting in combo box
6668: task scheduling
6669: Help with transpose?
6670: Are you telling me all a virus has to do is run from XLSTART to
6671: IF statement
6672: Logging data to worksheet
6673: Insert a Row - Variable Location
6674: Which references will I need to reinstall on a new machine?
6675: Unprotect entire sheet
6676: Creating a macro to filter data on multiple sheets
6677: Custom menu items in a copied workbook
6678: Set Pivot Table Pages
6679: Copy and paste every x number of cells
6680: Application.FileSearch Problems
6681: If cell 'a' matches cell 'b' then copy cell 'd' to cell 'e'
6682: List all link cell to other workbooks
6683: Help with Autofill
6684: Run a Macro just after i open a workbook EXCEL
6685: referring to a textbox on a different userform.
6686: RTD Links retain previous values in certain conditions -- bug?
6687: Run Time Error 3343 - Unrecognized database format:
6688: AutoFilter Trigger Calculation
6689: Pagefield - select "(All)"
6690: Sum column values and insert result in last cell with VBA
6691: Saving w/ Stronger Encryption in Excel 2007
6692: Change in cell disabling events
6693: send email macro with Outlook running
6694: paste file name of an OFFice program into a cell
6695: last record
6696: Vacation Accrual
6697: VBA - Copy paste all Modules
6698: Excel 2007 data query parameter issue
6699: Duplicate in Row
6700: Sendmail, XL97 vs XL2k
6701: Evaluate text formula in VBA
6702: Sumproduct with Autofilter
6703: Duplicate removal macro keeps newest record
6704: Starting Outlook via FollowHyperlink event
6705: VB Help If Statement in Selection.ShowDetail = True
6706: activate code upon save command
6707: Macro not running anymore
6708: Sum all Cells with Interior Color Index not equal to 0
6709: How do I use VBA or a function to do a certain type of string work
6710: Pagebreaks vs page numbering
6711: Is there a steep learning curve for excel 2008 VBA as opposed to
6712: Problem with Worksheet_Activate event
6713: How come code written by a macro won't replay in excel 2008?
6714: Collect data from Excel files
6715: Automation error
6716: View workbook
6717: Function that groups together Overtime hours by 7.5 hrs
6718: Automatically Update Excel Graphs
6719: copy data to combobox value sheet
6720: List Problems
6721: Use VBA to display record with criteria
6722: Pivot table - sorting
6723: CommandButtons have stopped working
6724: How do I modify this macro to print the currently visible chart?
6725: Viewing hidden data
6726: Place TextBox Behind Other Controls on a Workshheet
6727: Command Button
6728: Filesearch won't clear
6729: >= Greater than or Equal to Not working
6730: Excel macro security fails in directory XLSTART.
6731: Font color in userform controls.
6732: User form- protection and password.
6733: Does a Pivot External Source to SQL Server stay connected?
6734: Open Office Outlook & Insert e-mail address
6735: override old format
6736: Formulas and Cumulative Values on a Line Chart
6737: conditional format question
6738: Problem using internetexplorer object to open a url
6739: Easier Method
6740: Difficulty with copy and paste
6741: Concatenate
6742: Date Format HELP
6743: VBA Structure Charts
6744: Adding images to cells via VB.Net
6745: How to add an array to a combo box with Excel 2003?
6746: Formatting Comments
6747: xl2007 speed issues
6748: Inserting Formula moving down each row
6749: Update Add-in
6750: Splitting cells
6751: Event Fired when Calculation Mode Changed
6752: Signature Authentication
6753: Relative links to worksheets
6754: Search and Find Missing In Action
6755: Comparing
6756: User Defined Functions to separate full names
6757: Listing Occurences of a date
6758: SharePoint Versions
6759: Selecting Shapes
6760: Adding Data Label value with VBA to a chart
6761: Error 1004 - Unable to set invertifnegative
6762: Conditional Formating
6763: Dependent Validation List
6764: Alternate row shading
6765: Is there a way to skip lines (insert value every other line)
6766: Locking Cells
6767: Processing a Message Box w/in a Macro
6768: VALIDATION FUNCTION HELP 2...
6769: import multiple CSV files into one Excel file
6770: End of Statement error
6771: Goto ("A1") in non active sheet
6772: CLEAR FIELD TEXT ON CLICK?
6773: how to access column 8 in my Range
6774: VALIDATION FUNCTION HELP
6775: Adding up range of cells exclude hide cells
6776: Excel Workbook.SaveAs xml spreadsheet gives garbage number
6777: with a macro open a workbook without the Auto_Open running
6778: Publishing a static table using jscript (Excel 2007)
6779: formula in code
6780: Color Change Syntax
6781: Delete last sheet in workbook
6782: Lookup from a list of numbers
6783: format the cell Comment
6784: Date field in user form & Loading a user form on opening workbook
6785: copy row based on match and multiple criteria
6786: 2nd TRY: Up from 2003 to 2007; code now throws error creating
6787: How do I make a cell truly empty using an "If" statement?
6788: Multiselect listbox if no selection
6789: Run-Time error '9' New Question
6790: vba - Select Used Range minus the top header
6791: Programmatically add worksheet function
6792: excel 2000 to excel 2007
6793: Procedure level array not recognised at module level
6794: Limiting access to registry
6795: 1004 Error on Workbooks.Open when run from inside IE
6796: Autocopy instead of autofill
6797: accessing Outlook Address book from Excel VBA
6798: Array function not working correctly if I use an "or - statement"
6799: Build data from Invoices.
6800: first space from the right
6801: Need worksheet Event for Sum
6802: Date Field Problem in Userform
6803: Start Word within Excel 2007
6804: VBA "Excel & Outlook" **************
6805: triggering Workbook_SheetCalculate
6806: Copy subtotal results
6807: programming issue when using Excel automation
6808: Super Hard Question
6809: Macro doesn't record action on a chart
6810: Re : Excel Chemistry Before and After
6811: Finding cells with matching data
6812: Replacing column values with formula values
6813: don't want column width change after refresh
6814: why does s.TextFrame.Characters.Text work only sometimes?
6815: PrintPreview problem in 2007
6816: Run-Time error 1004. Help Please!
6817: how do find the actual macro file on hard drive to send?
6818: Fast Way to Delete Rows from Big Spreadsheet (Using VBA)
6819: url content
6820: url content
6821: Excel file on Treo to dial phone numbers
6822: Excel 2003 Markers
6823: text in file
6824: 2007 Copy Paste Disabled
6825: Getting Worksheet_Change to Ignore First Row
6826: Highlight row any random color using same random color with duplic
6827: Setting a spreadsheet to auto sort data entry
6828: Auto select rows
6829: For...Next not copying text from Worksheet to Worksheet, but no Er
6830: Ranges and Number Combinations
6831: Ongoing Issue - I have tried to clarify so that you understand
6832: Strip 2 Numbers from a Hyphenated Range
6833: =?Utf-8?Q?Sections_of_Excel_2003_pivot_=E2=80=9Cbl?=
6834: combining worksheets
6835: Autofilter icons shifted to top row in Excel 2007
6836: Problem Setting Worksheet
6837: =?Utf-8?Q?1004_Error_in_VBA_Conditional_Fo?=
6838: How to Populate an Array with a Discontiguous Values
6839: VisibleRange references
6840: Adding the next month to a daily volume tracking sheet.
6841: Probably a rather basic question....
6842: Textbox problem in Userform
6843: changing date format
6844: does the "Range"object in excel2007 vba still have 65k row limit?
6845: Active chart screen visible coordinates
6846: Loop through sheets and get number of records per sheet
6847: Writing a VBA program
6848: remote references and external link values
6849: Help Loop question
6850: How can I automatically split values over specified time periods?
6851: select range
6852: Displaying Data in Matrix
6853: Combine two workbooks into one
6854: Creating a custom toolbar add-in in Excel 2007
6855: Workbook_SheetCalculate twice
6856: Make Sheets.(Range 1) = Sheets.(Range 2)
6857: DB2 timestamp format
6858: Options for error output in custom Excel functions
6859: Counting colored cells
6860: Loop through sheets & filter main sheet using sheet name
6861: Determine which variable was used in a calculation.
6862: Data check
6863: Count difference in days input box
6864: Closing a recordset error : Operation is not allowed when...is clo
6865: For To / Next loop doesn't update...
6866: Macro for popup window " update values"
6867: help with chart script and data labels
6868: =?windows-1252?Q?Using_SendKeys_to_=91activate=92_a_tab_on_2007_Ribbo?=
6869: Get templates files and copy data to it
6870: RowNumber corrupts formatting of Querytable
6871: Help to create worksheets from a list
6872: Matching cells (Excel 2007)
6873: Invisible sheets
6874: Using Data>Validation cell formatting to drive OnEntry/Intersect m
6875: VBA equiv. of Ctrl-Home w/Freeze Panes?
6876: Autoshapes on Excel user forms
6877: VBA, Search!!!! Help
6878: File on taskbar
6879: Error handling error # 1004 Run-time error
6880: Catch name of range
6881: VLOOKUP with two Workbooks
6882: Delete all object
6883: Conditional Formating
6884: VBA Sumif *********************** Help
6885: Check if data is inputed.
6886: "Workbooks.Open" fails with 2007??
6887: Code Needed for to check data input
6888: sort entire range with exception of last row
6889: VBA Time comparison not correct
6890: Looping
6891: Workbook Reopens After Close
6892: cell color change with click and record the the time and date
6893: Can't Click Anything
6894: How to calculate a Max / min in a matrix
6895: adjustine the range of a selected cell
6896: Comma replacement
6897: Excel crashes when I add VBA code programatically
6898: missing modules in personal.xls
6899: Conditional deleting of rows
6900: Problem with code - Help needed please
6901: Const and VBA values
6902: matching multiple columns on different worksheets
6903: Macro to Hide blank rows
6904: Forms TextBox Vertical Scrollbar
6905: setting delimiters
6906: Error Cell "#N/A"
6907: Combobox Error message in UserForm
6908: Center text in a shape textframe
6909: how do i separate addresses and place results in another cell
6910: Advice on code
6911: cells function
6912: find & replace
6913: Anyway to detect a new page
6914: Macro to copy and paste to another sheet, based on if-then-else
6915: Bind Event Prior to Print Preview
6916: how to declare a public workbook?
6917: Force CommandBar Position
6918: Check if file exists
6919: Remove Validation Input Messages
6920: Sql probleme on emty cell
6921: UserForm specs
6922: Print preview / full screen view problem
6923: always on top
6924: Sheets() and Window() Objects not working?
6925: how to add up string or text together
6926: Select one checkbox to Deselect another
6927: Vlookup
6928: error - select method failed - (columns.select)
6929: dsofile.dll changes lastsaved of non office files
6930: Importing data.
6931: VB for scatter graph help
6932: Auto Open macro go to beginning of week
6933: Inserting 3 blanco rows
6934: ParamArray passed multiple times in nested procedures.
6935: comparing two excel sheet and providing the outcome in a 3rd sheet
6936: comparing two excel sheets & showing matched data in 3rd sheet
6937: Using SetFocus with Frames
6938: Referencing the worksheet name in an excel function
6939: Programatically adding code to a worksheet
6940: social security number problem
6941: VB and Word
6942: Find, copy then paste problem
6943: Combine two Codes into one Sheet
6944: Clearing Duplicate Entries
6945: Click event sort ascending then descending
6946: Combobox_change event fires when a workbooks is saved
6947: Crystal Reports Newsgroup
6948: Mail merge macro: select recipients from Excel during merge
6949: Excel 2007 to SQL Server???
6950: Subtotal
6951: How to code a macro to sort a list of string?
6952: Replace string
6953: Urgent... Getting error in accessing named ranges in excel 2007...
6954: Create Pie Chart with Percentage and Show it on Userform
6955: Need help Finding row number of the last row with data.
6956: Just type the particular word
6957: Macro to generate worksheets
6958: pivotitems updating pivottable.... help!!!
6959: Find and display only duplicates
6960: Protect View Code?
6961: Excel export Issue
6962: InputBox positioning
6963: Compare cell and msg
6964: Date Formatting Within A Combo Box On A Userform
6965: duplicate vb projects occur when reopening a sheet
6966: Change enter key direction based on range
6967: Getting Path Of .XLS?
6968: .NumberFormat not getting applied?
6969: Hyperlink Base.
6970: Active sort / Copy
6971: Opening .XLS In VBA: Getting "Do You Want To Save..." Prompt...
6972: Problem where end time is less than start time
6973: changing properties of offset cells
6974: Running macro on multiple files
6975: Excel
6976: Web Query
6977: Adding values stored at relative cell references
6978: PivotTable
6979: A cell is in which named range?
6980: PROGRESS BAR QUESTION
6981: Get usable height with UserForm.InsideHeight.
6982: launching an external application within excel using contents of c
6983: How to bottom-align a control on a UserForm?
6984: formula error
6985: Query to look in default directory
6986: StatusBar not updating after Shell call and wait
6987: test
6988: Referencing cells online
6989: find a designated value in all workbooks in a designated folder
6990: TreeView node is Selected but grayed out--how set focus?
6991: Navigating Indentured BOMs (Parts Lists) in Excel
6992: Arrange Icons on Taskbar
6993: Excel 2007 VSTO 3.0 Intranet deployment issue.
6994: Excel does not get the FOCUS
6995: OnChange event attached to tick box
6996: Excel Medical Template Help Needed
6997: Excel Medical Template Help Needed
6998: object library or invalid reference
6999: Max of a range help
7000: how do I display the greater of 2 values in excel