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

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