PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 [121] 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164

  1. Run time error 424
  2. Is it possible to display information from 3 cells side by side in a single cell?
  3. [SOLVED] Access records via Excel VBa between dates
  4. [SOLVED] how to copy the visible cells of a table to another tab?
  5. [SOLVED] Find vs Match
  6. [SOLVED] In a workbook in several sheets - each sheet several macro at once
  7. [SOLVED] range copy with paste
  8. VBA Change ODBC Connection String (Excel)
  9. VBA to change column to row and store the result in new column
  10. [SOLVED] Open CSV File Automatic Separating Comma
  11. [SOLVED] Automating Date Entry
  12. [SOLVED] compare date in number and product
  13. search for data and delete rows containing it
  14. [SOLVED] Finding non-zero minimum in a dynamic array
  15. [SOLVED] Transfer values from sheet to textbox
  16. Using Min() in VBA
  17. Move various duplicate rows to new sheet
  18. Varible help?
  19. Copy range of cells between workbooks with same named sheets
  20. Excel VBA - vLook-Up if match first 2 characters of one column with another column
  21. Help on Shell and Class module
  22. [SOLVED] Updating sheet with data from another sheet
  23. Excel VBA - Delete last row containing data
  24. [SOLVED] VBA conditional formatting
  25. [SOLVED] Call Sub in module from userform
  26. Check 2 column and Combine Data
  27. savecopyas in event
  28. Filtercopy does not return records listed with criteria value below 7 characters
  29. [SOLVED] Consolidate spreadhseets
  30. [SOLVED] GetElementsByClassName With IE8
  31. Workbook -macros query
  32. Wrong line in the macro.
  33. [SOLVED] Adjust error calculation in VBA
  34. html problem with vba
  35. [SOLVED] Need: VB code to get values from different closed workbooks
  36. Copy & Pasting Overwrites My Data Validation
  37. if find string copy that cell to right column
  38. vba code move cell to next cell
  39. Worksheet change clears selection(s) on MultiSelect type listbox.
  40. Help to use an array for this little section of code
  41. Excel slideshow and data query help
  42. [SOLVED] Copy sheet into another workbook and put in alphabetical order
  43. Percentage Difference for Two Percentage
  44. Have Macro run when cell is updated
  45. VBA Script to Average Amplitude Values in Each Bin Range of a Frequency Histogram
  46. Information sheet or message in xlam?
  47. [SOLVED] Change the macro to search for a specific word (as written) and not close to it
  48. Call previous dictionary entry
  49. Rename buttons using loop and "i + 1"
  50. [SOLVED] RTE Error
  51. Unable to set FormulaArray Property of the Range Class - Using Replace Function
  52. [SOLVED] Ie Automation
  53. [SOLVED] Populating Listbox
  54. [SOLVED] Creating a unique id
  55. help with copy range
  56. Search for a string on all excel files inside a ZIp folder
  57. VBA Calendar
  58. Rename Code Modules Programmatically
  59. Extract values of a certain format
  60. How to copy format of a column using spin button
  61. Total data if salary each month is the same - VBA
  62. [SOLVED] 2013 CalcPad.xlsm in XLStart folder. Open Excel - "CalcPad.xlsm is already open."
  63. PivotFields class returns an error when .Function property is set
  64. Change Cell Color on Sheet "Statistic" if value is negative
  65. trasfer data from Lotus macro to Excal VBA macro
  66. blank row
  67. Barcode fonts
  68. [SOLVED] copy not contiguous cells via VBA
  69. [SOLVED] Date overlap
  70. Find a "zero" of an implicit function
  71. VLOOKUP returns #N/A
  72. [SOLVED] User input to delete value in named range:
  73. [SOLVED] Help with Loops
  74. Copy data from different workbook and consolidate into one masterfile workbook
  75. Fill a combobox with data found in a range based on worksheet chosen in another cbx
  76. Bill of Material
  77. [SOLVED] RunTime Error 53 : File Not Found error
  78. XML Data I/O
  79. Code to Group Worksheets when Printing and Print Preview - 2003 vs 2010
  80. Exel Crashes with Form Control
  81. [SOLVED] Sum from previous sum formula in a column to active cell
  82. Sumifs and dates
  83. [SOLVED] struggling with excel combo boxes macro
  84. Help with code
  85. [SOLVED] Range, Columns, and Copy
  86. find matching entry, then copy and paste
  87. Excel as Notify Icon
  88. [SOLVED] Help to Improve Double Loop Code
  89. Edit VBA to prevent paste but allow copy and save the file with a file name derived
  90. Create a simple chart in a sheet where a pivot table already exists
  91. Create Sheet if Workbook name contain some text
  92. [SOLVED] Need a little help with "totals"
  93. FORCE TO POPULATE CELL
  94. Copy Paste from multiple worksheets into one based on multiple criteria
  95. import txt. file to excel with vba
  96. [SOLVED] fill months following
  97. Loop through subfolders
  98. [SOLVED] VBA Auto SAVE - need help!
  99. [SOLVED] Error: Overflow
  100. [SOLVED] Parse Text And Read Into Cells
  101. [SOLVED] Allow only choose 4 colors
  102. Check whether numbers are sequential?
  103. Importing data from Header and table in Word to Excel.
  104. [SOLVED] Changing formatting by writing all cells to an array
  105. Help in VBA
  106. Hidden worksheet codes not working
  107. SaveasUI - Save as .xls not XLSM
  108. [SOLVED] Subscript out of Range
  109. VBA Auto generate numbering
  110. Trouble setting pivot page filter using VBA
  111. Merging Word Documents From VBA
  112. New to VBA Coding
  113. Excel record aggregation with VBA macro
  114. Runtime error 445, need help
  115. [SOLVED] VBA Scientific Format. Can I reduce a digit?
  116. Mathematical Excel Optimisation Challenge (production of units)
  117. [SOLVED] Increment Column Selection with InputBox
  118. Question regarding loops sum and average
  119. Sales Returns for FIFO
  120. [SOLVED] Kill Files that Begin With Something
  121. [SOLVED] Automatic Generate random unique time From 8 AM till 21 PM in range
  122. Format search results in a Multicolumn Listbox With Headings
  123. [SOLVED] Date range
  124. [SOLVED] Adding New Chart Series with Loop
  125. String length mismatch
  126. VBA - Change Decimal Separator
  127. Optimize a VBA loop
  128. [SOLVED] Creating an Array from a Table with only one row in it
  129. [SOLVED] Acceptable to use Goto
  130. Hiding Cols With VBA
  131. automation error
  132. Compiling and Exporting Information
  133. [SOLVED] Case Senerio and Offset That Creates A Data Validation Box
  134. Array for ActiveX Controls
  135. [SOLVED] Trying to find the next empty cell in a range Using With and Set method - Help
  136. [SOLVED] Increase number every nth year
  137. [SOLVED] macro button for copying excel data into multiple word docs
  138. [SOLVED] Directly Copy A Range from One Sheet to Another
  139. How to compare text in 2 cells and highlight incorrect text
  140. Excel VBA to Unhide rows with a specific value in a Range
  141. Printing an Selected Sheets
  142. How to add row into another worksheet based on multiple cell values?
  143. Multiple Column Listbox (with headers) = the bain of my existence
  144. How to Avoid Formatting Cells When Protected?
  145. Automating the use of translation.babylon.com
  146. VBA Userform (for Entering Data)
  147. Lookup column value and find value
  148. [SOLVED] Userform for Entering Data in Excel VBA
  149. Slow Import from Web
  150. How modal forms work
  151. [SOLVED] Print a changing range based on date values
  152. [SOLVED] Put data from userform into specific place.
  153. [SOLVED] ListView Run-time erro "13"; Type mismatch
  154. Run-time error when using OraOLEDB.Oracle Provider
  155. Autofilter based on content in cells
  156. [SOLVED] Writing and Reading the Same Set of Ranges
  157. How to send email from excel using VBA with Cell Range (Including Images) as Email Bo
  158. [SOLVED] Download file, how do I know when the file is downloaded?
  159. Issues getting data in PowerPivot from Access
  160. [SOLVED] Iterate values through cell using VBA and record result
  161. Iterate values through calculation using VBA and record results
  162. Runtime error copying value from one worksheet to another in same workbook
  163. [SOLVED] Trying to add variables into Worksheet statements and can't get the right syntax
  164. VBA combo boxes
  165. [SOLVED] When does a Chart object become a ChartObject object
  166. Userform submitting a date in format "mmm-yy", but a small problem arises.
  167. VBA - Rounding Goal Seek result
  168. I Can't change <SELECT> html tag using VBA
  169. remove an item from a combobox.
  170. multiple word files tables to excel vba
  171. [SOLVED] Need Help Removing quotes and double quotes from my Excel Spreadsheet
  172. Merged mulitple sheets of existing workbook into one sheet
  173. Excel 2003, worksheet_change to insert current date when a cell is colored yellow
  174. Merge Single Worksheets from Different Files into One Workbook AND Replace Formulas
  175. trouble selecting sheet
  176. [SOLVED] Remove Text
  177. VBA Code - Novice Here, Sorry!
  178. Searching information in different bases
  179. [SOLVED] Worksheet not updating with data from VBA
  180. Update workbook data from another workbook
  181. [SOLVED] Code works in Macro, but not in Function
  182. creating Parameters in Excel using VBA
  183. Help Require in VBA
  184. [SOLVED] Problem deleting a legendEntry
  185. [SOLVED] Runtime Error 1004 on 2nd run
  186. Automatically Inserting Rows with Date, Each Worksheet
  187. Help with VBA Events - some work and some don't
  188. [SOLVED] Help me improve some old code
  189. Clearing contents of all worksheets in a excel workbook
  190. [SOLVED] Find every instance of a word, then find previous instance of another word
  191. [SOLVED] Correct Row/Column Numbers with INDEX and MATCH
  192. [SOLVED] Help With Worksheet Change event
  193. Calculate sub shift hours
  194. Adding Item to Reference Library
  195. [SOLVED] Help with a msgbox :)
  196. [SOLVED] Userform doesn't open unless Excel is the active application
  197. Delete Powerpoint slide which contains zero values
  198. [SOLVED] Find and Match Formula
  199. EXCEL/Quickbooks HELP!!!
  200. Complex Filtering & Copying With VBA (Need Help)
  201. Finding duplicates and replacing.
  202. One rate sheet - multiple customers/multiple rates based on the one sheet
  203. Help jump Columns
  204. [SOLVED] De-Duplication & Merge with multiple criteria
  205. VBA Help please (Novice)
  206. [SOLVED] Delete duplicate rows Excel 2003
  207. [SOLVED] VBA MsgBox Width in WIN7
  208. [SOLVED] Excel Crashes when Saving workbook
  209. [SOLVED] FileSearch Macro error
  210. VBA Help Needed with Dynamic Sum Formula
  211. Utilizing Stored procedure parameters in VBA
  212. Annual Time Sheet (including flexi/TOIL) - Enter Negative Time/hours
  213. VBA / Excel / Formula / Examples
  214. count numbers that are in two sets of numbers
  215. Problem with ProgressBar
  216. [SOLVED] Rank/ Sequence of Repetition
  217. Copy and Paste if Value changes
  218. IE.navigate not working on VPN
  219. To obtain the coordinates
  220. How to create VBA Function from VBA Macro - Inverse of Matrix in Excel VBA
  221. [SOLVED] Formula Q: referencing first column number that meets specific criteria
  222. [SOLVED] Calling custom class method through variable
  223. Replace All fires WS_Change for every cell
  224. Check If Files In A Folder Are Open Without Knowing Name/File Type
  225. [SOLVED] Lookup up formula
  226. Setting a timeout for Excel workbook
  227. Import Sharepoint list into Excel
  228. Macro for inserting new rows conditionally.
  229. Help with code
  230. Copy cells from an open workbook to a closed workbook
  231. [SOLVED] Close workbook without save prompt?
  232. 2013 Slicer Events
  233. Excel functions
  234. [SOLVED] Is this efficient?
  235. Need Macro to Copy and Ignore Duplicate
  236. macro to find modified date of file
  237. [SOLVED] What does it mean to click on a cell?
  238. Possible to have a macro "Rewrite" another macro?
  239. Export / Print all Charts in Workbook to PDF
  240. [SOLVED] How to use the AddComment method of the range object
  241. Issues getting text into a text box on a website form
  242. Latest file name in the folder path
  243. file exists or not
  244. [SOLVED] Headings in formulas
  245. PowerPoint crashes while copypasting diagrams from Excel
  246. Login into intenet website not recognizing password via VBA code from excel
  247. Input date into input box on website not working correctly
  248. [SOLVED] Small Delay when showing Form
  249. [SOLVED] Ratio being force formatted into Time
  250. [SOLVED] Counting specific figures based on pivot table data