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 166 167 168 169 170 171 172 173 174

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