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

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