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. Variant-type object array element is deallocated by With statement
  2. Show graph in userform but via sharepoint
  3. [SOLVED:] Lookup formula not returning the correct result
  4. [SOLVED:] Userform is not displaying anything when i change a "box" to visible or not visible
  5. [SOLVED:] Worksheet SelectionChange Error - Target.Address - if statement
  6. Script not working after moving data to SharePoint
  7. [SOLVED:] Help: Capture file location on the first opening of a workbook/workbook open event
  8. Column getting truncated
  9. Open and Close Workbooks | best Practices
  10. Excel file always opens in read-only mode when opening from sharepoint
  11. [SOLVED:] How to create a values only copy of WB while keeping formatting and filters in tact?
  12. Excel VBA folder-search-tool
  13. Application Visible with more than 1 workbook
  14. [SOLVED:] mismatch when sum values in multiple textboxes
  15. [SOLVED:] Cumulative based of criteria
  16. Opened Workbooks are still opened after executing Macro (Workbook.Close doesn't work)
  17. HELP!! can't figure out details for a file-combining macro
  18. Not Getting Sum Result From All Sheets
  19. expenses compared to the budget
  20. Market data and charts
  21. copy with loop double variable
  22. [SOLVED:] Date Help
  23. Macro for inserting rows if value
  24. [SOLVED:] Multi-sheet procedure
  25. [SOLVED:] How to Change the Value of a Cell based on the values of two other cells
  26. [SOLVED:] Zero Out Column if another column has a certain qualifier
  27. [SOLVED:] Create Summary
  28. How to prevent duplicate value
  29. Shell Command results in Runtime Error 5 - but path appears to exist
  30. [SOLVED:] Countif in VBA Module
  31. New to VBA: Compile Error Syntax Error
  32. Add the value taken from the user to my range for ActiveX ComboBox
  33. Loop Through Data Validation List and Copy Values Given By Each Item
  34. [SOLVED:] Re-Arrange Columns after Import
  35. [SOLVED:] Is it possible to store range objects in an variant array?
  36. [SOLVED:] clear dependant drop down boxes
  37. [SOLVED:] VBA code to pull in data from SQL table
  38. copy information with vba
  39. [SOLVED:] Deleting Worksheet Stops Script
  40. Pull SQL Data into Excel by Date Range
  41. Setting tab order, adding ability to stop/start code and refine functionality
  42. Macro Or Command To Change Photo In Excel - Urgent Weekend Help Needed
  43. Data validation and manipulating input
  44. [SOLVED:] Check if within multiple ranges check problem
  45. [SOLVED:] Compile Error Private WithEvents oCbarEvents As CommandBars and Private Sub Worksheet
  46. strAddress = .ActiveCell.Address Run-time error 438 when switching sheets
  47. [SOLVED:] Delete Rows if Cost Code Bucket is Zero
  48. SUMIFS on multiple rows and columns, based on a mapping
  49. File Selection- if user cancels- End Sub Then call macro1
  50. How to split a big text file (with more than 500000 lines) in to smaller files
  51. [SOLVED:] Conditional Format:Need to compare 2 cells with any other 2 cells for the same number
  52. wrap broken lines in one line in a given text or log file
  53. Copy text from text file between keyword in rows.
  54. [SOLVED:] insert auto serial number in user form
  55. [SOLVED:] storing processed data
  56. [SOLVED:] Textbox within a Frame in UDF unable to take focus. Why not?
  57. [SOLVED:] looping through functions
  58. Helper columns to solve problem
  59. search and copy the line
  60. Help to remove duplicate strings from table
  61. VBA script updating values other sheet
  62. [SOLVED:] Formula with OR condition does not return expected result
  63. How to close all the hyperlinked files automatically?
  64. Array loop values
  65. Make a declared variable equal to values from multiple cells
  66. [SOLVED:] HOW TO CONCATENATE: IF(condition;result string;result string) result string?
  67. Sleeper: Find a Partial Match from Location Sheet
  68. [SOLVED:] 3 questions regarding VBA Excel
  69. [SOLVED:] Expanding the range
  70. [SOLVED:] need Code to select value from dropdown list using numeric values
  71. [SOLVED:] MkDir and "Path Not Found" Run-time error 76
  72. Criteria based lookup
  73. Instant change between one textbox to another.
  74. Insert Multiple Image and name image in Userform
  75. Copy and paste styles of diagram
  76. [SOLVED:] VBA Excel - reduction of lines
  77. Copy and paste specific ranges
  78. [SOLVED:] create Summary report from information on the DATA Tab.
  79. Checkboxes and filters
  80. [SOLVED:] Copy Data from one workbook to another - based on tab name
  81. [SOLVED:] VBA Userform macro help for range dates
  82. [SOLVED:] Search for name and letter matches and split equally
  83. Search for a match files using value from selected cell in Folder or Subfolders
  84. Return latest result for work schedule
  85. [SOLVED:] Every time you open the UseForm, it generates a new code
  86. Image embed
  87. [SOLVED:] AutoComplete doesn't recognize Cell A1, it starts getting information from the second
  88. check if serial number is repeated
  89. Can someone recommand an obfuscator for xlsm?
  90. Doppelte Einträge zusammenfassen
  91. [SOLVED:] How to range table "t" from ActiveSheet "Charts"?
  92. How to convert number of color to RGB?
  93. [SOLVED:] how to force users to enable macros
  94. [SOLVED:] IF Countif and Textjoin - Help required
  95. [SOLVED:] Help for viable registration solution and code improvement
  96. [SOLVED:] How to pull information from different columns of data from the same row?
  97. Help needed- Analysis of splitting of orders
  98. Need vba to code to split data depends upon col I:I and col J:J
  99. VBA Help on drop down list
  100. HLEP!! I need help modifying this code.
  101. insert selected row from listbox to excel table
  102. Worksheet Change Referencing Cell in Another Sheet
  103. Automatically delete rows after time period using time stamp (have partial code)
  104. Excel counts a blank as zero. Why not leave it as a blank?
  105. [SOLVED:] Cross section by matching column and row headings
  106. Filter values ​​from a table and display them in different textboxes
  107. Price List Comparator
  108. Filter By Multiple Criteria then match results to different workbook & paste new data
  109. A search code with three possible results
  110. [SOLVED:] How to save multiple selected information from a LISTBOX?
  111. Making code more concise - VBA scrape information
  112. [SOLVED:] Pivot table
  113. VBA Code for pasting today's date into a text box
  114. [SLEEPER:] VBA Email TO Cell that contains IF formula
  115. Vlookup to ListObject "Table copy, paste"
  116. [SOLVED:] Saving is not creating a new record line, but saving over it
  117. VBA Help to change Form of Smart Art Nodes
  118. Finding Shape types WITHOUT selecting the shape ?
  119. How do I get one cell color to change based on another cell color that changes?
  120. Why do macros work once and then stop? Example is included
  121. [SOLVED:] Putting Values with Leading Zeros Into CSV file
  122. Copy data from user selected source file to current open workbook
  123. Using the TEXT function and Concatenate function in one formula
  124. How to Solve using CurrentRegion if cells in Table is Protected
  125. Copying values from one column in a sheet to another column in another sheet once.
  126. VBA - function Vlookup
  127. Can I add cell info into a comment box via a formula?
  128. VBA - Range of object _ Global failed
  129. Help : Error on saving workbook to dektop synced with OneDrive
  130. Lookup to add Products from one table to another VBA
  131. code to setup crop dimension
  132. Does anyone else have this error 1004?
  133. Picture shows in userform with search
  134. [SOLVED:] Fastest way to transform data
  135. [SOLVED:] show multiple separate information
  136. Retrieve formulas and autocomplete
  137. [SLEEPER:] Loop between two tables to sum their matches
  138. VBA - Problem in .range
  139. Log Scale graph in excel
  140. [SOLVED:] Formula to FIND specific TEXT within a worksheet
  141. how to create a portfolio Optimimizer using VBA
  142. [SOLVED:] Move data around in workbook
  143. Item number with current month
  144. Linear interpolation with lookup of two values
  145. Using VBA Set for workbook and worksheet
  146. VBA Code for Highlighting Cells based on If then Rules
  147. Create a Userform with a Textbox and link it to a Cell or Table
  148. VBA Code for PDF of Vibile Sheets in array
  149. Method 'SaveAs' of object'_Workbook failed
  150. [SOLVED:] Keycode 13 only for textbox input on userform
  151. [SOLVED:] Conditional Formatting borders around cells with formulas
  152. [SOLVED:] Making a function based on Find having IF
  153. Simple code that refreshes link to another excel file with Password
  154. [SOLVED:] Sort range from one empty row to the next empty row Custom
  155. [SOLVED:] Repeat Search Function
  156. [SOLVED:] Formula to format the cell? (so text gets enough space)
  157. Reference a cell.
  158. Macro not working for fetching data from Active Directory
  159. After user clicks 'Notify', do this
  160. Unrecognized text on different computer
  161. Compare the selected item of a listbox with a table
  162. errors on Macro code for consolidation
  163. How can we use VBA/Macros Excel for solving this interesting simulation question?
  164. [SOLVED:] Help with simplifying my background substraction (data analysis)
  165. Transferring data workbook to workbook
  166. Sleeper: VBA using Loop
  167. Sorting two way pivot table with VBA?
  168. Sleeper: Linear interpolation in Excel
  169. Sorting and cutting part of the sort into a new tab
  170. [SOLVED:] Msg error: "Exception from HRESULT:0x800401A8" when refreshing reports automatically
  171. Extract a number from text in cell using VBA
  172. [SOLVED:] IF Else statement not executing properly
  173. [SOLVED:] Pin Folder to Windows Explorers Quick Access in VBA
  174. VBA code
  175. [SOLVED:] Code only doing it for cell not entire column
  176. [SOLVED:] Can a Header
  177. Precedents arrows state
  178. Haven't encountered this before, what does it mean?
  179. Dynamic update for each userform textbox through looping
  180. How to make a macro work in selected worksheets and how to fix a macro error from CF
  181. Help duplicating from one cell onto multiple rows
  182. Modeless Form Closing
  183. [SOLVED:] Problem in concatenate
  184. Macro called from Menu no longer responding
  185. Break record row into multiple rows
  186. [SOLVED:] Can't loop a macro
  187. Insert Row & copy and paste formulas in new row
  188. [SOLVED:] Lookup values from a range with partial non-ordered keyword strings
  189. Creating a VBA to find and delete duplicate values within Excel workbook
  190. Reformat found data and count equal 'strings'
  191. Insertion range depends on meeting conditions
  192. [SOLVED:] How to add row in second Sheet using ActiveCell in first sheet?
  193. [SOLVED:] Impossible to insert
  194. Editable listview items
  195. VBA - Prompt To Save Excel File In Variable Location
  196. help with the debug
  197. Help to fine tune the codes | transform data, delete blank rows and then autofill
  198. Removing leading letters in a text using VBA
  199. Add some cell values as notes
  200. [SOLVED:] How to assign a worksheet change codes to a button to refresh the values
  201. Range Address Variables
  202. VBA Macro Sort Range
  203. Fiter, Copy and Paste unique values in the next available row of another workbook
  204. Replacing hyperlinks with find and Replace
  205. Copy the last 3 columns
  206. [SOLVED:] VBA code to search on folder and sub folder for file named in worksheet
  207. How to cycle through control sheet in workbook
  208. [SOLVED:] Combinng Ranges into One
  209. Macro That Inserts a New Row and Defines Formulas to Cells
  210. Move To Top Of The Sheet
  211. Crossposting VBA Question - Overlapping Text Boxes with all Shapes
  212. Adding label for msoDropdown control type
  213. [SOLVED:] Copy the Last Row Within a Range and Paste to Last Row in Another Sheet
  214. Cannot get Application Caller to work
  215. excel help
  216. Function behaving differently
  217. Hide/unhide columns
  218. Noob question about Do-Until Loops
  219. DO NOT Copy Data Under Table/ Copy Data from Table to Table
  220. macro to add or subtract date and time from yyyymmdd_hhmmss format
  221. Need help with sending multiple .bcc from range in excel
  222. [SOLVED:] VBA doesn't compares correctly via greater than string comparison
  223. [SOLVED:] Multiple Individual Exclusive Checkboxes with data validation Macro (code here)
  224. [SOLVED:] autofocus on userform after print out
  225. VBA - Flat Text Import Changes
  226. Filter for suffix [x] when a comparing file has _x suffix
  227. [SOLVED:] Help with Code to splitting values into 2 columns
  228. [SOLVED:] Small VBA Macro: introduce cell text into a CountIF formular and get output
  229. [SOLVED:] Shape Colors Updated per Cell Value (150 cells and shapes)
  230. Using a class module for several userforms, identify which userform is active
  231. [SOLVED:] vba code if lastrow is full, it errors out
  232. vba print 2 ranges in one page
  233. Transfer data from one work to another
  234. [SOLVED:] Scale display vba code
  235. [SOLVED:] Delete rows with previous dates
  236. [SOLVED:] Copy Multiple Range on Multiple Sheets.
  237. [SOLVED:] Code searches entire workbook-Need only specific coulmn + keep formatting after Paste
  238. [SOLVED:] Change active page of Vision object in Excel
  239. VBA Form Source List
  240. How to calculate a route / find waypoints between start and destination
  241. Transfer specific columns from sheet to another
  242. [SOLVED:] Refresh custom formulars that checks background color and output as 1 or 0 (File here
  243. Convert ASCII code back to text with StrConv + vbUnicode (VBA)
  244. Quick VBA Question - Adding Another Condition - Use ElseIf?
  245. Need Help converting columns to YML format
  246. [SOLVED:] Help needed to count duplicates but derived by a column of values
  247. A macro to show and hide specific rows in specific worksheets
  248. Finding duplicates in 6 columns by excel VBA
  249. [SOLVED:] Vlookup in Different Workbook - Sheet Looping
  250. Delete Button on UserForm won't Cooperate (Run-time error ‘1004’, Range Class Failed)