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 165

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