Log in

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. run-time error "4198" (1 replies)
  2. Target Specific Array Elements Group (2 replies)
  3. find a date in a range - exact match (11 replies)
  4. loop an excel table to update styles (17 replies)
  5. VBA code for attendance template - In time & Out Time (2 replies)
  6. [SOLVED:] How to find out URL from where on the website CSV data is benign downloaded (8 replies)
  7. [SOLVED:] VBA problem: Merge two sheets into one (18 replies)
  8. Pasting a range into an email, while also adding text to body and keeping signature (1 replies)
  9. I want to find first 0 in column in vba (3 replies)
  10. [SOLVED:] VBA: Error when range(variant) condists of only 1 cell (12 replies)
  11. [SOLVED:] Print userform to PDF (22 replies)
  12. [SOLVED:] Opened/Populated by MS ACCESS, Excel WB can't see cell value on WB OPEN Event (3 replies)
  13. Copy Ranges between sheets with Cycles (7 replies)
  14. select a range using 2 address and find if range is empty/has data (6 replies)
  15. Using Wildcards (4 replies)
  16. VBA-XML-SEARCH ZIP AND HOUSE NUMBER (1 replies)
  17. Matching multiple values from different column (1 replies)
  18. capture few columns from xml file (9 replies)
  19. Keyword Identification and Changes (2 replies)
  20. VlookUp giving random values instead of #N/A. (5 replies)
  21. Vlookup #N/A using VBA (1 replies)
  22. Saving a workbook with macros when they open it. (4 replies)
  23. Can I Change Textbox Languege ? (1 replies)
  24. Follow Up Question About the Ribbon (8 replies)
  25. Text Boxes visible not visible on user form (10 replies)
  26. Variable sheetname in formula (2 replies)
  27. [SOLVED:] Data grouping? (6 replies)
  28. vba - help removing selection (2 replies)
  29. [SOLVED:] HELP FIND HIGHEST VALUE USING VBA (3 replies)
  30. Copy Data to Next Empty Rrow (2 replies)
  31. Text Box formatting. (1 replies)
  32. [SOLVED:] Array formula - need formula to pick from 2 ranges to use in calculation (1 replies)
  33. Sleeper: Declare Global Variable - Private Worksheet (9 replies)
  34. [SOLVED:] Multiple Offset - Insert into (2 replies)
  35. [SOLVED:] Complicated formula, i'm at a loss (3 replies)
  36. [SOLVED:] form question (5 replies)
  37. Help Needed Regarding Linear Interpolation and Extrapolation (3 replies)
  38. Help: "Method 'SaveAs' of object'_Workbook' failed" - Tried different codes, no luck (3 replies)
  39. Using VBA to import BDH from Bloomberg (3 replies)
  40. VBA separate uppercase words from lowercase words. (2 replies)
  41. Hide Pivot items based on table (2 replies)
  42. Generate personal schedule from overview (3 replies)
  43. Delete out of date rows (5 replies)
  44. Authenticating Access to an External Database using VBA (2 replies)
  45. User Form Help (3 replies)
  46. [SOLVED:] Change VBA code to fit 64-bit environment (18 replies)
  47. Loop for excel functions (4 replies)
  48. [SOLVED:] Sumifs? can this be done with a ranged criteria? (1 replies)
  49. using excel to collect and store data (6 replies)
  50. VBA: Splitting a big string with no good delimiters (6 replies)
  51. Worksheet edit VBA code (1 replies)
  52. Drawing two para (3 replies)
  53. [SOLVED:] How can I print the sorted array back into worksheet? (4 replies)
  54. [SOLVED:] Skip Empty Cells or Ones with a Word in Them and Run function (3 replies)
  55. [SOLVED:] Modify line of VBA code (5 replies)
  56. [SOLVED:] VBA TO Correct Date format (5 replies)
  57. Help with a Formula (3 replies)
  58. [SOLVED:] 2 Column messagebox spacing of data (5 replies)
  59. Deactivate "EDIT" after Digital Signature (or add Password)? (3 replies)
  60. [SOLVED:] PrintForm opens a 'greyed out' UserForm1 (8 replies)
  61. Copy paste loop Multiple sheets column wise (1 replies)
  62. Adding Formula in VBA ...Need help (0 replies)
  63. A way to speed up code VBA in for loop with ExecuteExcel4Macro (10 replies)
  64. Sharepoint coding (0 replies)
  65. Application Match error 13 (1 replies)
  66. [SOLVED:] Deleting a row (3 replies)
  67. VBA: compare values in columns and list the missmatches in a new sheet (2 replies)
  68. Excel Data Tables (3 replies)
  69. NEED HELP! Average Duplicates and Print them separately (2 replies)
  70. placing different windows on my screen (11 replies)
  71. How to sort Listbox with Multiple columns (3 replies)
  72. Sort Userform ListBox (2 replies)
  73. VBA Help in Converting text result of Date into Date Format !! (1 replies)
  74. [SOLVED:] How to display all hidden rows and columns (11 replies)
  75. [SOLVED:] Need Help with VBA, True Vs False (6 replies)
  76. Output VBA Code Results to ThisWorkbook (2 replies)
  77. need help writing a code for copy and paste special (values) (3 replies)
  78. vba consolidation of specific sheets data and Pasting in specific Mater sheets (5 replies)
  79. Entering input Data to next available cell in another sheet (2 replies)
  80. sieve of eratosthenes vba code explanation (4 replies)
  81. VBA Excel 2013 Prompting users to select a file & retain value. (4 replies)
  82. Search Replace Offset - substitute (2 replies)
  83. [SOLVED:] Transpose Table - Removing Duplicates (11 replies)
  84. [SOLVED:] Need help in ExecuteExcel4Macro VBA (7 replies)
  85. Update row cells based on listbox cell value (9 replies)
  86. Kill Excel after user close userform (9 replies)
  87. [SOLVED:] Filtering SKU List to Show Items with Multiple Descriptions Only (5 replies)
  88. save selected worksheet as separate pdf file (5 replies)
  89. [SOLVED:] calling selected shape help (1 replies)
  90. the body of the vba generated mail is empty (2 replies)
  91. Sleeper: VBA hour calculation over 24h (7 replies)
  92. [SOLVED:] Copy Module to New Workbook (26 replies)
  93. Grouping of defined sections (3 replies)
  94. Save a part of the sheet with a specific name (1 replies)
  95. [SOLVED:] Mismatch Error (2 replies)
  96. Signature Block on Locked Form - Workaround (7 replies)
  97. insert sumifs with last row based on another sheet (7 replies)
  98. [SOLVED:] Test for Overlapping Project Assignment (7 replies)
  99. [SOLVED:] Create a production schedule from a different workbook using cell values. (13 replies)
  100. different footer for every page (2 replies)
  101. [SOLVED:] Permutation Combination using Macro (9 replies)
  102. Can multiple Range but not individual cells. (5 replies)
  103. [SLEEPER:] Search for Values that meet a Criteria and Paste Location in a New Sheet (1 replies)
  104. Macro to move from windows media player to an Excel worksheet (6 replies)
  105. Search From a User Form and Display Results in a Worksheet (1 replies)
  106. Creating a official form in Excel using VBA!! (2 replies)
  107. [SOLVED:] Condensing IF statements (4 replies)
  108. Making VBA program more user friendly (8 replies)
  109. Find duplicate values accross columns per row (7 replies)
  110. [SOLVED:] Assigning two macros to one shape to run on different actions (5 replies)
  111. Find value in Excel from Array within Word (5 replies)
  112. Advance filter help (8 replies)
  113. Time Conversion into text (1 replies)
  114. [SOLVED:] Formula Support Issue (2 replies)
  115. [SOLVED:] Composing Email using Macro (6 replies)
  116. VBA ListBox List - Want only selected columns to be displayed (21 replies)
  117. Multiselect Multicolumn Listbox allow users to add data? (3 replies)
  118. [SOLVED:] Range Syntax (13 replies)
  119. [SOLVED:] Copy Column Table x times and add counter (2 replies)
  120. vba to copy and paste each file name (2 replies)
  121. vba help (1 replies)
  122. [SOLVED:] Windows Folder Creation From Excel & How to Check A Folder Has Not Been Created (2 replies)
  123. [SOLVED:] Open CSV UTF-8 files (no acces to editing BOM) (3 replies)
  124. Error 400 (1 replies)
  125. [SOLVED:] VBA plot a Scatter graph data - X and Y axis data taken from sheet row by row (16 replies)
  126. [SOLVED:] Message Box Still Appearing When Code Runs Correctly (6 replies)
  127. progress bar (1 replies)
  128. Call code when text is in a Range, NOT every time it appears in the Range. (9 replies)
  129. No Locals Window (2 replies)
  130. Listbox items as Hyperlinks (1 replies)
  131. Get XLA file (3 replies)
  132. code optimization (10 replies)
  133. [SOLVED:] Trying to copy multiple worksheets into new workbooks (3 replies)
  134. [SOLVED:] complie error: Expected: end of statement (3 replies)
  135. VBA error 1004 (2 replies)
  136. [SOLVED:] Print Hidden Worksheets from Userform (13 replies)
  137. Unable to use formula in Shapes (3 replies)
  138. Management weekly report (3 replies)
  139. [SOLVED:] Faster way delete strikethrough (2 replies)
  140. [SOLVED:] Array Filtered without Spaces after 1aRow (6 replies)
  141. Ctrl Shift Enter on FormulaArray VBA (2 replies)
  142. FIFO-GAIN-STOCK PROBLEM (1 replies)
  143. Why will my loop not move through different worksheets (tabs) (2 replies)
  144. [SOLVED:] Autofilter with variable criteria & field (2 replies)
  145. Using Countif iterating thru rows in a sheet (1 replies)
  146. APIs for Hiding UserForm "X" and\or Adding UserForm Minimize (32 & 64 bit) (8 replies)
  147. [SOLVED:] Error on adding validation list (2 replies)
  148. [SOLVED:] How to open windows folder using double click on a cell. (11 replies)
  149. Monthly/Yearly Bills workbook (0 replies)
  150. [SOLVED:] Passing UserForm Text from One Excel Application to Another (9 replies)
  151. VBA SUMIFS Function (2 replies)
  152. Copying rows over to new workbooks based on unique column values (5 replies)
  153. Win10 + Excel 2016 fail to connect WebDav with ADODB.connection (1 replies)
  154. How to combine Selection. PasteSpecial and Selection.insert Shift in one VBA code ? (1 replies)
  155. Generating a Pareto chart based on date (2 replies)
  156. Run-time Error 1004 (1 replies)
  157. VBA Auto Filter (5 replies)
  158. Export / Save as PDF in specific folder. (1 replies)
  159. [SOLVED:] Comparing two range of cells to find out the number of matches (4 replies)
  160. Help about dynamic value table array in Vlookup (10 replies)
  161. [SOLVED:] Dynamically populate multiple ComboBoxes (5 replies)
  162. [SOLVED:] Generating results from different sheet by filters (10 replies)
  163. how to check network file through VBA (4 replies)
  164. Multipage Tiff file in Excel VBA Userform (6 replies)
  165. [SOLVED:] Another Delete Sheets Macro (3 replies)
  166. [SOLVED:] How to set formula equal to a series of numbers (2 replies)
  167. UserForm has Minimize Button. How do I execute it via code. (11 replies)
  168. [SOLVED:] Help to get one or more filename from folder in excel and make it hyperlink to it (4 replies)
  169. Copy Cells with Range(Cells R,C). match returning location in numbers (4 replies)
  170. Check If URL Returns 404 (1 replies)
  171. [SOLVED:] Subtotal?? (8 replies)
  172. [SOLVED:] Search workbook for worksheet name, IF yes then run code, IF not display MsgBox (2 replies)
  173. VBA with Vlookup dynamic (5 replies)
  174. [SOLVED:] Option Button Value (3 replies)
  175. count up cell value by one and automatically be protected (4 replies)
  176. Remove duplicated values from 1d string array vba (1 replies)
  177. Counter sums quantity of files in said folder but doesnt update unless double clicked (10 replies)
  178. insert rows and paste in section from a range (4 replies)
  179. VBA code to make sheet uneditable after I save (4 replies)
  180. Workbook that forces users to enable Macros and automatically closes after some time (3 replies)
  181. Email userform (13 replies)
  182. Sheet Not Fully Active after Selecting or Activating (9 replies)
  183. [SOLVED:] VLOOKUP and skip blanks (5 replies)
  184. [SOLVED:] Convert C# to VBA (15 replies)
  185. Export From Excel To Access! (0 replies)
  186. Migrated to Office 365 from Office 2016 - MACRO no longer functions (1 replies)
  187. [SOLVED:] Remove permanent comment from cell (1 replies)
  188. [SOLVED:] Multiple users (2 replies)
  189. Sort using part of cell value (2 replies)
  190. [SOLVED:] Save Each Worksheet to Individual PDF (6 replies)
  191. Help with coding for labels (1 replies)
  192. Storing row numbers (4 replies)
  193. [SOLVED:] Create table for each name in specific column (2 replies)
  194. Formula to check for embedded object and return a checkmark (5 replies)
  195. Find Text String in Range then copy cell into another range (1 replies)
  196. [SOLVED:] Chinese Encode in VBA (6 replies)
  197. vba consolidation of specific sheets data and Pasting in specific Master sheets (2 replies)
  198. alternative to VLOOKUP for large range (5 replies)
  199. [SOLVED:] -- (Double Unary) (2 replies)
  200. Generate random number of strings that are stored in an array . (7 replies)
  201. Excel formula (1 replies)
  202. VBA CODE showing result as #VALUE! (2 replies)
  203. vba code not working (0 replies)
  204. problem with getelementsby... (4 replies)
  205. Excel VBA to import txt file AND automatically insert rows (1 replies)
  206. Read multiple .txt files and copy specific text to excel (1 replies)
  207. [SOLVED:] Run time error 13 Type mismatch (4 replies)
  208. Loop inside a function to retrieve data (1 replies)
  209. [SOLVED:] Find and replace multiple values in Excel using VBA (10 replies)
  210. Need some help with a macro (9 replies)
  211. [SOLVED:] Using VBA to save a xlsm file (Excel 2013) (3 replies)
  212. match supplier name in form with standard supplier name (2 replies)
  213. Need to filter data and create new workbooks (4 replies)
  214. autogenrate id in userform (1 replies)
  215. Sum? sumif? sumproduct? (12 replies)
  216. Combox Depending on others (2 replies)
  217. Looping through columns to merge files into a PDF (4 replies)
  218. Finding Duplicates in Two Columns (1 replies)
  219. [SOLVED:] Beginner help on creating excel visual tool through VBA (4 replies)
  220. [SOLVED:] What determines the size of the userform other than screen resolution? (4 replies)
  221. [SOLVED:] Change a range of cells based on value in specific cell using VBA code (2 replies)
  222. [SOLVED:] the remove method in Collection and Select Case (2 replies)
  223. Toggle Button copy same toggle instructions (6 replies)
  224. [SOLVED:] array filling with multiple unique names (5 replies)
  225. add supplier & customer (8 replies)
  226. Extract data from text file to Excel sheet (1 replies)
  227. [SOLVED:] Change Cell Value As Part Of Copy/Paste Operation (2 replies)
  228. Error after RmDir !! (4 replies)
  229. VBA current cell value = another cell value if criteria met (5 replies)
  230. [SOLVED:] Array formula? (7 replies)
  231. Combo box Duplicates (5 replies)
  232. [SOLVED:] Need a help with loading data using class module (Derivative & Portfolio) (4 replies)
  233. Help with creating duplicate sheets, combo box are linked together (0 replies)
  234. [SOLVED:] Finding the length of elements in a 2D array (3 replies)
  235. [SOLVED:] Edit new code to allow update of posiitional references to be edited by user. (2 replies)
  236. [SOLVED:] Need an advice for searching function (28 replies)
  237. [SOLVED:] Excel Userform Directory - search button using checkboxes (5 replies)
  238. VBA: Copy row to the last line of data (4 replies)
  239. Copying a section if item from a drop down list is selected (16 replies)
  240. problem with data extraction with VBA from Web site (2 replies)
  241. Run-time error 1004 (4 replies)
  242. [SOLVED:] Need help with VBA conditional VLOOKUP on another file (3 replies)
  243. Sumproduct across ranges with varying sum values (4 replies)
  244. sub that creates two arrays month and dayslnMonth (14 replies)
  245. Remove Duplicate VBA (5 replies)
  246. Export to XML (2 replies)
  247. [SOLVED:] VBA Copy formula x times to the right based on value in cell (3 replies)
  248. Application Error (10 replies)
  249. Project Explorer taking up full screen (3 replies)
  250. Merge Multiple Workbooks into One (3 replies)