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

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