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

view full version: back to formated view

701: Copy Row to Another Sheet Based on Cell Value
702: Date formula to return two digit year
703: Inserting Drop down on sheet - Array needed
704: auto adjusting cell size and row height
705: consolidating workbooks into one workbook
706: Insert long formula
707: Excel Add-on Development.
708: Merging Blank Cells
709: Cant connect to Access database from excel using vba
710: Skipping Blanks
711: Programmatically determining if workbook is opened as Read Only
712: **Pop-up message prompting for user information**
713: Change columns after certain point
714: Programming help needed
715: Copy sheet in a workbook
716: Opening file question
717: Sum and Counta function in Listbox for UserForm
718: VBA count number of cells
719: VBA Programming with Checkbox
720: List of function descriptions and field descriptions
721: Sorting makro
722: e-mail excel files from a folder
723: Open Excel locked file using password without office installed
724: Data Validation Question
725: Anti-Virus Program Deleted VBA codes from Personal.xls
726: Perplexing string manipulation problem
727: Opposite of a marco
728: Sentence Capitalization - Revisited
729: Custom number format
730: PublishObjects.Add in reverse order
731: Editing Marco
732: how to do these things in Excel with and without VBA?
733: Call a UserForm based on ComboBox selection
734: modification of Per Jessen Macro- paste/overwrite
735: Excel Pop-up Question
736: AutoFilter or something like it
737: Hover Text that carry over into Web Format
738: Updating a Excel calendar based on range values
739: checking if a sheet exists
740: VBA Function Not Recognized or Execution Issue
741: Lookup Table and output three or more entries
742: Debugging
743: Copying worksheets into separate workbook and emailing separately.
744: How to force close the worksheet without having Excel prompt?
745: Error Messages: 'Text String is Too Long...'; 'Can't Record Macro'
746: running an excel program
747: Code for inserting Comment field with spreadsheet protection
748: Breakdown grouping
749: Disable the redX in a form
750: Delete rows if range is null and not in color...
751: Excel Screen refresh while VBA is running
752: .Sendmail to Multiple Internal Addresses
753: Never used a button before
754: Column width reset
755: Column values
756: Send Mail to multiple recipients in same network....
757: Look for Sheet name, and then skip...
758: Makes Changes to Closed Excel File on LAN
759: adjust .Sendmail for mutiple recipients on internal email network
760: Source of Data Files?
761: Excel (not spreadsheet) Screen refresh while VBA is running
762: Macro to retrieve stock quotes in Excel 2007
763: Drop Down List Showing Two Cells Info
764: checking numbers in VBA
765: Create automated Supplier Scorecard Report from Excel
766: Hide Autoshape based on Cell Value
767: calculating difference between date/time fields
768: Font size and color change for selected cell only
769: Rebuilding a corrupted workbook
770: Refedit-automation error
771: Filling in the blanks methods?
772: Session Times
773: In my Excel "active application add-ins" not properly enable
774: String Functions
775: Loop Do Until question
776: VBA Function to Increase the Selected Cell Font.
777: Copying an unspecified column range
778: Copying Entries Help
779: Job survey
780: The Differences between running a Shell in Excel 2003 and Excel 20
781: The Differences in the Shell Command in Excel 2003 and 2007
782: manipulating results of autofilter in vba
783: how do i call an Outlook Procedures in Excell Macro
784: Application.EnvelopeVisible=False problem
785: Page number within a worksheet
786: strange VBA behavior with named ranges
787: Grey screen issue - HELP
788: Problem with ActiveWorkbook.EnvelopeVisible
789: Reformat & Combine Word Tables, Then Import Into Excel
790: Chart Macro?!! Help Please
791: Chart Macro?!! Help Please
792: Sendmail vs different computers
793: application defined or object defined error
794: Marco formatting
795: Excel List Object Field Types
796: Looping through clumns and switch to rows
797: Using Ctrl + Copy and Paste across multiple instances of Excel
798: Design Mode switching is not working
799: Insert Image in an sheet
800: Conditional Statements
801: Workbook_Open does not run for Addin
802: 255 char limit on TextBox
803: Autosave doesn't work
804: help with Application.EnvelopeVisible
805: if then statement help
806: goto statement in VBA
807: Error occur while loading Sheet1811111111111111111" Help Please!
808: if then statement help
809: Excel List Object Field Types for SharePoint
810: Extract data to new sheet
811: Make a shortcut to a file - code
812: taking characters from last name and first name to create a passwo
813: Email to a distribution list in Excel - Simple Version Please
814: ReadOnly
815: Creating a hyperlink in VBA for an autoshape
816: Marco
817: Application.calculate not working
818: Runtime error 91
819: Some changes in a Macro ..
820: delete last line of numbers
821: Can't delete sheets in Excel
822: for each c in range.. how set counter "minus 1"?
823: Why does Sheet.Range("A1").Select not work!!!
824: Moving entire column
825: Deleting Macros in Personal XLSB file
826: Public Sub For UserForm TextBoxes & Named Ranges
827: Almost there with procedure error
828: I hope someone can help me with a formula
829: Protection So Workbook Can't Be Opened
830: Manual Calculation
831: putting info from one file into another using vba
832: save file with macro - web folder
833: Check Validation via Excel VBA code.
834: Getting result from a Pivot Table - Question
835: Process of records
836: Delete All Rows Above Trigger
837: Function is Excel 2007
838: comparing rows of two workbooks
839: Fill Down VBA help please
840: Open Calculator in Office 2008 by vba
841: Programmatically retrieving constants
842: Enable users to edit charts on a protected worksheet
843: Summing up subtotals according to conditions
844: vba custom function sum highest consecutive numbers in range excel
845: adding code in runtime
846: selection.sort process increase file size by 4.5mb
847: Saving File
848: Trace errant formula to stop annoying message
849: clear rows and insert records from recordset on refresh
850: User-defined function to give blank cell?
851: Need Help
852: Initilizing the New DropDown feature
853: clear rows and insert records from recordset on refresh
854: InsertLines Syntax
855: Custom toolbar adding and deleting
856: Print format
857: Hiding two columns
858: Conditional Format and auto filter
859: Help needed: Getting all sheet setup data from one workbook to
860: Macro to protect and unprotect all sheets of the current workbook
861: Macro to test sheet and workbook protect and unprotect status.
862: Window Trigger Event.
863: What is wrong with this range???
864: How do i save a image to the same folder my .xls file is located?
865: protecting and unprotecting more than 1 worksheets
866: cpu saving..
867: Protecting and Unprotecting more than 1 worksheets
868: opening an excel file from a website using vba
869: Calling a subroutine with a command button
870: Insert page number into cell
871: Importing text file without end-of-line delimiter?
872: "=" in text file formatting messes with my code loop- more elegant (and faster) solution?
873: Setting Criteria in VBA
874: Opening an XLA and then forgetting about it?
875: VBA SharePoint List Field Type assignments
876: Combine Custom Function Results
877: Solver and 64 bit
878: Copy Sync with Shell
879: Always accept my changes
880: matching
881: Moving the Mouse...
882: searching in visual basic
883: sequencing numbers
884: Deleting duplicate rows when creating a CSV automatically
885: older version and newer version of excel
886: Finding Workbook name - HELP
887: Transposing based on cell value
888: Line numbering in code
889: Strange character pops up in my spreadsheet
890: e-mail
891: AddIn: IDTExtensibility::BeginShutdown hiding GUI elements too lat
892: Run Every 15 mins
893: Grabbing string values from the end of a string of an unknown length
894: changing views from outlok to excel VB Help
895: Update multiple pivot tables
896: Accept EULA ?
897: Problem with macro in Excel 2007
898: How to change the text color using formulae?
899: Excel 2003 - Shapes
900: Workbook_open Event
901: Event triggered in Excel's cell by DDE
902: re arranging data in a worksheet
903: Sun a macro when a cell is calculated
904: What are the events get fired when Excel gets loaded with all shee
905: excel combobox
906: How to stop UDF in Original ref'ng copied range
907: Link: Unable to read file
908: Set row number for Date function in while loop?
909: Show Last Record in the Listbox when userform Loads.
910: How to show Last Record in ListBox when loaded.
911: Comparison Macro + In string text highlighting
912: Calculating Hours from Textbox Times
913: Searcing for an Excel event.
914: I don't know how to write a macro that would update the workbook
915: Combobox.DropDown not working
916: Why Excel 2003 VBA program not working in Excel 2007?
917: Adding a Leter to a Numerical Value on Exit
918: Little help with "Number stored as Text"
919: SpinButton Incrementing time behaviour
920: Sentence Capitalizatio
921: Error: DISP_E_TYPEMISMATCH while interop.excel
922: HTML INTO EXCEL
923: How to get variable from a formula
924: how to display error message?
925: write a macro to show the edit.find dialog box in excel
926: unloading XLL files in Excel
927: do until loop
928: Changing text to formula in a range of cells
929: A workbook of macros which runs on external workbooks.
930: file naming during auto-saveas
931: Move columns by selecting the day of the week
932: commission
933: page number display
934: Hide Blank rows from ListBox1
935: Excel Pre-2007 Menus Question
936: Activate macro in another book
937: Personal.xls Issues in Excel 2007
938: special sort option
939: Can't find project or library
940: formulas
941: inserting rows into worksheets
942: Run a macro from one excel file to another excel file
943: VB Msgbox result
944: Passing variables between excel files
945: Print separate PDF File for each group
946: Activating mozilla firefox and entering an address
947: Select....Case macro in Excel 2007
948: Splash Screen / userform
949: Print area multiple sheets
950: Automatically update data validation list
951: Changing the font size and color in a message box
952: need some array help
953: Golf match Leader board spreadsheet for recording up 200 players
954: out of memory error
955: Protect the structure of the workbook
956: Auto-formatting Time with a Query Table
957: Burberry Sunglasses SG_BU009 - www.luxury-gift.org
958: Armani Sunglasses SG_AR059 - www.luxury-gift.org
959: Dior Sunglasses SG_DI0704016 - www.luxury-gift.org
960: VB Syntax to close Excel workbook not saving changes
961: Error Upon Opening Excel
962: Get cell value from other workbook
963: Difficulty with macro in excel 2007.
964: Cannot remove password from file
965: get the sum of the value by filtering 3 columns
966: Slow VBA code?
967: Worksheet range copy
968: VBA for pivot tables
969: Set Focus On ComboBox
970: prevet users to view and modify MS query
971: Data concantating
972: Visual Basic Applications - Help Files
973: For Each Next... what's wrong with my code???
974: parsing Html page
975: Date Question
976: Positioning datalabels
977: excel macro with word
978: Calculation-problem
979: LOCATION OF WORKSHEET'S AUTOMATIC PAGEBREAKS
980: Displayed caption font increases on each click
981: Comparing multiple rows of data
982: Modifying code
983: HELP=> Problems Copying WorkBook Sheets
984: BIFF / Office 2007 Question
985: HLOOKUP Can't Search by Lookup Value
986: HLOOKUP Can't Search by Lookup Value
987: question on hiding rows
988: Column password protection
989: DATE ALARM
990: How could I make the contents of a Cell "Flash" like a warning.
991: ADO read of Access...
992: Cannot get message box to show
993: Investor's Knowledge Analysis
994: Opening a file from another file
995: Search for calculated duplicate using worksheet events - Possible?
996: Copying Worksheet from one workbook to another
997: Copying Worksheet to new workbook with VBA
998: Unique combinations of records in a list
999: position of inserted picture files in Excel 2007
1000: Copy & paste rows after found text to different wb and delete them
1001: Extract Comments to Cell and search with AutoFilter
1002: Another 'Last cell in column' question
1003: System Date - Network
1004: Excel2003 - possible to lock/protect individual cell(s)? maybe wit
1005: Pulling text from the right end of a string
1006: Copy charts to powerpoint
1007: Sub Total in worksheet or SUM IF function
1008: pulling in a table with formulas
1009: VB Cond. Formatting of Formula Cell
1010: paste into destination w/o overwriting existing
1011: Color Index for light yellow & Code Help?
1012: How can I specify which cell has focus?
1013: Strange error when changing locked status of cells
1014: Finding and highlighting duplicates across multiple worksheets
1015: Upload Data from Sheet1 on Local Machine to Sheet1 on LAN
1016: Puvot Refresh
1017: Moving from VBA to VSTO
1018: VBA Book
1019: Adding many textboxes on Form
1020: display problem with listbox
1021: Excel bypassing Word password
1022: Bug in Excel 2007 using Names/Ranges?
1023: Unprotecting a Workbook before exiting
1024: Bug in Excel 2007 using Ranges/Names?
1025: Open file ready only
1026: Count font colour in a cell
1027: Dynamic property names
1028: Wookbook speed
1029: How to email an embedded object
1030: UDF behaving very oddly -assistance or please suggest alternative.
1031: Change A Line in A Module Using VBA Code
1032: Run a macro if file is a template
1033: Chart Window's class name in Excel 2007
1034: Range statemeny query
1035: Cleaning file
1036: Public Variables
1037: Need Help to Control the UDF from re-calculation
1038: Pulling cells from multiple reports into a new column
1039: Enabling Turst access to Visual Basic Projects
1040: Locking cells in Auto filtered list
1041: Update links automatically when opening file
1042: how to call excel.range.errors in vc++
1043: Returning the name of a module
1044: 'Trusted Publisher' under Vista
1045: Macro attached to Menu Command Button
1046: File opens another file runs macro and closes
1047: E-mailing a worksheet only from a workbook
1048: Drop Down Box
1049: Separating a master file into many workbooks
1050: Total or summing in a workbook within a folder