View Full Version : excel answers


  1. Error 1004 on second line trying to set value or formatting of cell or range
  2. Finding Exact Difference between Three Numbers
  3. Crystal Reports & Excel VBA
  4. How to create macro to copy worksheet and paste values only
  5. How do I link commandbuttons to combobox selection?
  6. How to create a Macro that runs on a selection of cells
  7. Create a clickable button in Excel that opens a blank email in outlook but attaches t
  8. Copy past on multiple criteria like dates and center
  9. Excel Macro Runs Great But Have to Close Multiple Sheets
  10. Many data in excel document
  11. Desktop organization
  12. Excel 2016 3D Maps Timelines and Time Series
  13. Use a string to represent a range object
  14. How to get data back from excel sheet?
  15. Excel vba problem help!!!
  16. I was only sorting Excel data
  17. controling graphs and Charts
  18. Textbox problem with khmer unicode
  19. Exel file after restoration.
  20. using macros to open a file whose path can be varied
  21. External platforms suitable for hosting Pivot Charts with slicers
  22. Expand and Collapse Rows
  23. How do I filter data using one of two different fields?
  24. How do I compare two worksheets, and get the results in other worksheets?
  25. Excel cannot open .xlsx format file
  26. Error handling on hyperlinks to folders (VBA)
  27. Change Language (for all of office products, including word)
  28. Merge multiple workbooks into one
  29. Excel VBA VLookup assitance
  30. Excel Array issues
  31. Error loading query data to excel spreadsheet-[datasource.Error}ODBC:Error{42S22][ibm
  32. Sorting Problem (maybe)
  33. unexpected error while runing data analysis on excel 2013
  34. Convert string to Control in VBA
  35. Excel List VBA Question
  36. Fetch size of the file in excel sheet
  37. Database.xls' is in a different format
  38. Creating a macro to save files based on text in cells
  39. Delete cells based on conditional formatting color
  40. VBA AutoFilter with variable in Criteria
  41. AES Encryption Algorithm for VBA EXCEL
  42. Sorting Traditional Chinese Characters differs from 2003 and 2013
  43. Analysing data from multiple row records
  44. Help looping thru multiple workbooks to merge data into Masterr worksheet
  45. How to fix Run-time Error 52 for Microsoft Excel 2003?
  46. Open Spreadsheet as modal Datasheet form in Excel, is it possible ?
  47. Need help activating a newly downloaded CSV
  48. doubt on calculating difference vba/excel
  49. I need help on If, Mactch and Index function returning error
  50. Linking tables to make Pivot Table Excel 2010
  51. How to set 3 attempts in VBA Excel
  52. Plotting 3 variables on 1 graph
  53. Excel VBA Code Help needed please - Still learning
  54. Excel file error?
  55. Find a single zero, special charcters and return row number
  56. Highlight cell if
  57. VBA: Loop hangs up after one pass
  58. Using If Function in VBA for different conditions and Different criteria
  59. Append 0 character in cell value along with cell values in Excel
  60. Find out the TOTAL number of “Principal” and “Vice Principal” working in ONE particul
  61. #Ref! error - how to solve
  62. Cannot open the file in excel
  63. Strange Date Format
  64. Excel Row copy through VBA
  65. Need VBA to click link on website and open new form without logging out
  66. every time I run the programme below, I get Compile Error 'End if without blockif'
  67. Remove any number of spaces before and after slash
  68. Use Enter key to navigate in special way
  69. Diasble Ctrl + Alt + Delete
  70. EXCEL Q: How to Color Shapes Based off Date Ranges in Various Cells?
  71. Corrupt Excel File
  72. Vlookup with criteria
  73. Copy specific rows to other sheet
  74. Method 'Range of object '_Global' failed
  75. Disable editing from a microsoft query
  76. Making Railway Time table in excel using combo boxes & Text Boxes
  77. How do I get imported data to refresh each time the Excel file opens?
  78. error with "ElseIf"
  79. Pivot data from consistent tables across several sheets (tabs)
  80. Object Error
  81. MACRO<> Pick a number from excel and go to web page copy text nad paste it into excel
  82. How do I change the font size of an option button form control?
  83. VBA in Excel
  84. Referencing Tabs in Excel without Manually Input
  85. A sheet I have been using will not open.
  86. Date filter for all periods
  87. Total Hours Productivity within 8 hours a day
  88. help with this visual basic code from my excel file
  89. Probability and distribution Problem?
  90. How to Create a Multi-Select Listbox in Excel Worksheet
  91. Running total to sum text boxes in a form
  92. What does this: '! mean in Excel
  93. Inventor - barcode formula help
  94. Error Message on Connection Failure
  95. Create graphs, loop through columns
  96. Autofill based on text box input
  97. Find Text And Replace Entire Line in Notepad with New Text
  98. I don't know why I get a type mismatch( cmbcountry.AddItem rs.Fields(0) )
  99. failure move-function: low respons
  100. Populate spreadsheet with month, day and 24 hr time in half hour increments
  101. Dates entered as dd/mm/yyyy in VBA UserForm are stored incorrectly
  102. How can i pull data from web into excel cell?
  103. resolving wasp labeler system error 3061 too few parameters
  104. #NAME? error
  105. how to block the cells that is uneditable
  106. Calling a SQL Server Stored Proc that contains a CREATE TABLE
  107. please help me excel vba for gtalk
  108. Converting yyyy-mm-dd to yyyy-mm
  109. To Do list help - to add two more columns to the current code
  110. How to inactivate an Excel built-in function
  111. how to create a database by just clicking a command button
  112. Using a counter within a name in VBA
  113. How to export the file uploaded on Sharepoint site using Excel VBA
  114. Moving values from one excel to another search based on string
  115. How to Hide powepoint file using VBA
  116. Errors while creating Charts in Excel VBA 2010
  117. Excel 2010 Macro not working on Windows 7 but same works perfectly on XP
  118. Runtime error 1004 Document Not Saved
  119. How to open excel in read only mode?
  120. I need help with setting up a lookup table, or another way to do this
  121. Plotting Data According to Time
  122. Assign text to slides
  123. Whats wrong with my code? Keep getting arguments not optional error
  124. Using COUNTIFS for counting multiple criteria
  125. VBA code randomly stopping
  126. Finding last row with data working for column A, but not B or C
  127. "Object Required" error during Excel Solver Loop
  128. Difference between millitary date/time in standard time
  129. Create button to copy values over worksheets
  130. How do you add 2 numbers together in VB from a worksheet?
  131. Macro for PivotTable Field List Options
  132. Varied Job Schedule, Excel
  133. VBA to Replace "-" to "_" in excel sheet name
  134. How to use excel VBA to SQL query and compare data?
  135. After changing to a new worksheet, vba excel breaks down
  136. I need a macro to delete rows in various worksheets
  137. save an excel file (with multiple linked sheets ) as values only
  138. What does ### mean in Excel?
  139. Excel Macros