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. [SOLVED:] Data lost when sending file as attachment (1 replies)
  2. [SOLVED:] compare workbooks version number (2 replies)
  3. Emailing Named Ranges Using VBA (6 replies)
  4. [SOLVED:] automatic E-mail using Arrays in VBA (2 replies)
  5. VBA IF STATEMENT HELP (0 replies)
  6. How to Merge/ Combine , three worksheets ? (13 replies)
  7. Reformat string (2 replies)
  8. autonumber a string within a cell (6 replies)
  9. Comparing 6 coloumn and highlighting the difference (3 replies)
  10. [SOLVED:] Expand rows automatically based on grouped rows (3 replies)
  11. Macro which auto runs when every excel workbook is opened (5 replies)
  12. save and Merge PDFs From Excel (2 replies)
  13. [SOLVED:] Search for files with ending ".csv" in a folder and work on it (5 replies)
  14. [SOLVED:] My first excel VBA project (5 replies)
  15. VBA help (0 replies)
  16. [SOLVED:] Change "Selection.CurrentRegion.Select" so macro captures cols A-Q, non-contiguous (9 replies)
  17. [SOLVED:] Reformat data in specific way (5 replies)
  18. [SOLVED:] VBA Vlookup Reflect Data to TextBox1 (12 replies)
  19. Dim - Compile Error: Syntax Error (4 replies)
  20. Use Bookmark To Fill in Word Document From Excel Data (8 replies)
  21. Vlookup or Index/Match code to find the value (5 replies)
  22. VBA code to find fraudulent activity in data (25 replies)
  23. Pattern Style (1 replies)
  24. Make custom formula with VBA's (11 replies)
  25. [SOLVED:] Trigger event when pressing F12 (3 replies)
  26. [SOLVED:] Multiple URL's to Get External Data (19 replies)
  27. Plot a AREA in a X,Y scatter plot (3 replies)
  28. Copy the entire row if the value in column R is greater than 1 and insert above (3 replies)
  29. How to transfer userform data to two diffirent sheets in diffirent cells? (0 replies)
  30. how to display Unicode Hindi characters into combobox from mysql database (4 replies)
  31. Macro to copy selected cells in a row and paste into new sheet at specified locations (2 replies)
  32. [SOLVED:] Move an excel file to another folder (7 replies)
  33. Copy single row from multiple workbooks to one main sheet (12 replies)
  34. read contents of pdf (1 replies)
  35. Run-Time Error '1004': Method 'HasRoutingSlip' of object '_Workbook' failed (1 replies)
  36. [SOLVED:] Disbale Shift Key on workbook Open (14 replies)
  37. VBA Delete for Shapes Range Very Slow (30 replies)
  38. [SOLVED:] Multiply two matrices (5 replies)
  39. [SOLVED:] join an merge cells in column A but at same time the same rows in columns B and C (20 replies)
  40. Excel 2007 3d animation engine - Tutorials (2 replies)
  41. Userform Help (2 replies)
  42. Interactive maps (4 replies)
  43. Open and Link Spreadsheet Using VBA (0 replies)
  44. Combine all text files from multiple folders into one worksheet (38 replies)
  45. Partial String Search cross sheet reference (12 replies)
  46. Comparing 2 Workbooks AND Their Worksheets (14 replies)
  47. [SOLVED:] Copy and paste data from a source file to destination file. (2 replies)
  48. Delete duplicate rows (3 replies)
  49. .Click in IE only works every few attempts (0 replies)
  50. "The Master" ,The one Book that rules them "ALL." (0 replies)
  51. Need help with VBA Error (22 replies)
  52. RT Error 424 - Object Required, when UNIONing 2 ranges in order to sync 2 columns (13 replies)
  53. [SOLVED:] Help with a difficult sort (7 replies)
  54. [SOLVED:] Help with formula please (7 replies)
  55. [SOLVED:] Seperate unique accounts and manipulate data (4 replies)
  56. Duplicate value removal across sheets and rows and columns IN A FILE (2 replies)
  57. [SOLVED:] How to write last row update record in excel into txt file ? (6 replies)
  58. [SOLVED:] Highlighting every other row containing data (8 replies)
  59. [SOLVED:] Adding more drop down list with my macro? (6 replies)
  60. Opening and Saving spreadsheet (1 replies)
  61. [SOLVED:] IF statments with weekday (2 replies)
  62. [SOLVED:] Importing file with date that changes daily (10 replies)
  63. [SOLVED:] Rename Files By Adding Last Modified Date (19 replies)
  64. Encrypt Decrypt Excel cells/ colums (7 replies)
  65. calculating time display when the macro is running (the time is a lot while calcule) (2 replies)
  66. how to search the next value in excel (3 replies)
  67. VBA to centre range of images in cells (1 replies)
  68. Extracting resume data from word to excel (2 replies)
  69. delete text from word (1 replies)
  70. Get the shape's RGB value (4 replies)
  71. Separating data with VBA (8 replies)
  72. Problem with MkDir (4 replies)
  73. Sleeper: Lotus Email Attachments, How to better Optimize my Code? (0 replies)
  74. [SOLVED:] Using Countif formula in vb (7 replies)
  75. Use KB shortcut keys to return a value from a range (2 replies)
  76. transfer data from excel to word (7 replies)
  77. Remove Duplicates and Replace Content Cell (3 replies)
  78. Caculate Distance between 2 points on x y scatter plot chart (3 replies)
  79. [SOLVED:] How to save as txt file name depend on current date and time (1 replies)
  80. [SOLVED:] Using autofilter to loop and count visible cells (2 replies)
  81. Macro flickering (15 replies)
  82. Macro(s) for importing txt-file (0 replies)
  83. Send data from excel with API (XMLHTTP in VBA) (4 replies)
  84. Please help _table update (6 replies)
  85. Copy and paste not working for macro (1 replies)
  86. Freeze one cell after data is entered (16 replies)
  87. [SOLVED:] Wanting to change the range in a Macro (4 replies)
  88. multiple times same control wit same function after click (5 replies)
  89. Easy Excel Formula Problem (4 replies)
  90. Whats wrong with my code, copy paste does not change Array formula (30 replies)
  91. VBA Excel - Macro simple - help needed (2 replies)
  92. [SOLVED:] Using VBA SUMIF with multiple conditions (5 replies)
  93. Designating Master file to excel (3 replies)
  94. Create ppt from Excel using macros (7 replies)
  95. email sending (1 replies)
  96. [SOLVED:] random unique images (4 replies)
  97. [SOLVED:] Help With Macro to Attach Multiple Items To Outlook (4 replies)
  98. VBA to save as not saving values. (10 replies)
  99. Copy and Insert Rows based on value in column R (3 replies)
  100. Combo Box selection = 2 values set (4 replies)
  101. [SOLVED:] Loop through the record and summarized (4 replies)
  102. Excel crashing after running macro to work with autocad and after deleting column (3 replies)
  103. [SOLVED:] Creating a history (7 replies)
  104. Loop through specific range of dates do something and then do it again for new date r (3 replies)
  105. [SOLVED:] Checkboxes (2 replies)
  106. [SOLVED:] Searching for date in array (4 replies)
  107. VBA to copy files ( list ) from location ( different locations ) to another folder (3 replies)
  108. [SOLVED:] add random picture to Image in Userform (1 replies)
  109. Remove cell data for numbers over an average amount (6 replies)
  110. Index into specificied collection is out of bounds error (1 replies)
  111. Creating a database using a VBA code with user from (7 replies)
  112. Search in multiple workbooks to identify duplicate values (1 replies)
  113. Add sequential # to userform once saved (11 replies)
  114. parsing txt log to excel table (8 replies)
  115. [SOLVED:] Delete cell data if value is high (6 replies)
  116. A-Z processing of folders (8 replies)
  117. VBA not working (20 replies)
  118. [SOLVED:] Helping a student automate a couple of sheets (22 replies)
  119. [SOLVED:] Copy and paste loop help (4 replies)
  120. Triggering a VBA Sub with DDE/RTD (28 replies)
  121. [SOLVED:] Problem with .Find in Loop. (2 replies)
  122. Activex Controls Combo Box unique values (4 replies)
  123. Track updated data in table (1 replies)
  124. [SOLVED:] time degrees to decimal degrees (3 replies)
  125. Macro to Edit Links ? (12 replies)
  126. Pivot 1004 run error why? (2 replies)
  127. How to make excel vba crash proof? (8 replies)
  128. [SOLVED:] Macro not working while sending email (7 replies)
  129. Pivot table Error (1 replies)
  130. [SOLVED:] VBA to add series to graph only if data in column. (2 replies)
  131. Clear and restore conditional formatting of different cells before printing (3 replies)
  132. VBA code for Data Entry (13 replies)
  133. [SOLVED:] Vlookup or indirect,Help (8 replies)
  134. counting non numeric with pivot tables (4 replies)
  135. Delete duplicate rows based on 2 conditions using VBA Macro (Beginner) (2 replies)
  136. Acceleration of working Script. Ideas? (2 replies)
  137. Using Calculated Field to Return the Difference Between Two Columns (1 replies)
  138. Generate a series of column data with a condition (2 replies)
  139. VBA to help copy and paste few columns from pivot table 2 another table within sheet (10 replies)
  140. Formula visible cells (1 replies)
  141. Macro to format 2 cells adjacent to each other (9 replies)
  142. [SOLVED:] Sort using the active cell value (3 replies)
  143. Import data and remember file path (1 replies)
  144. [SOLVED:] Build parent/child hierarchy (5 replies)
  145. Pivot Table VBA (5 replies)
  146. Problems with Sum Function (5 replies)
  147. Get the reference from other sheet & go next row automatical (2 replies)
  148. [SOLVED:] Filtering data on multiple conditions (12 replies)
  149. [SOLVED:] Bulk Export Worksheet Code (11 replies)
  150. Deleting text after a specific character (1 replies)
  151. Copying table to another sheet on worksheet change (4 replies)
  152. [SOLVED:] Inserting Picture (2 replies)
  153. Send or data transfer multiple conditions (12 replies)
  154. Text Comparison between a column and a table is not working. (5 replies)
  155. Run time Error 1004 - Unable to get the Picture Class..(Inserting URL images) (4 replies)
  156. [SOLVED:] resize word pictures (3 replies)
  157. VBA insert formula based on another cell selection (1 replies)
  158. [SOLVED:] Need help constructing a vba code to show frequency of given values within delim data (2 replies)
  159. RANDBETWEEN not stopping (2 replies)
  160. transfer data (9 replies)
  161. Visual Basic run-time error 1004 work around (13 replies)
  162. Using Input Box Variable (3 replies)
  163. Formulas with Minus (2 replies)
  164. [SOLVED:] Newbie help on row count as range (5 replies)
  165. Double Type error 13 (2 replies)
  166. Running Code in Visual Basic Window Versus in Excel (7 replies)
  167. Userform vlookup, copy row data, display each found in sequential order in same form (1 replies)
  168. Selecting the row with the highest value (4 replies)
  169. Creating and displaying 16 frames on a userform each frame two labels. (6 replies)
  170. [SOLVED:] Loop values from data validation list vba (12 replies)
  171. Count if vs a trade with 'todays date formula' help (2 replies)
  172. Filter ShapeCount for Grouped Shape (4 replies)
  173. [SLEEPER:] objFolder.GetDetailsOf not working (21 replies)
  174. Problem in converting charts in workbooks to pictureP (2 replies)
  175. How to get the name of USB port name (6 replies)
  176. Using Excel VBA to Scrape Web Table Data (0 replies)
  177. Find and Replace (2 replies)
  178. [Novice] VBA Looping Macro (6 replies)
  179. Email macro (0 replies)
  180. [SOLVED:] Show Area of Freeform Shape (7 replies)
  181. Mass Find and Replace VBA - Need Help (13 replies)
  182. Programatically Add Reference (1 replies)
  183. [SOLVED:] Speed up VBA code (8 replies)
  184. [SOLVED:] Modifications to macro that copies cells that contain the name of a worksheet (2 replies)
  185. Help in VBA to transfer data into multiple files in a folder (5 replies)
  186. Do tables work with well macros. (4 replies)
  187. Saving Autocorrect entries into different languages using VBA (0 replies)
  188. [SOLVED:] Send Data to Alternate Userform (2 replies)
  189. Run time error help (4 replies)
  190. Variable in Loop (6 replies)
  191. Link last Checkbox in Column to Cell below (3 replies)
  192. update date automatically hen saved (3 replies)
  193. How do I populate a listbox in Excel Userform with data from the non active sheet (7 replies)
  194. [SOLVED:] hh:mm:ss conditional formatting (7 replies)
  195. [SOLVED:] Need Help with this macro, please! need to return unque values from within range (7 replies)
  196. Pivot Table: pct by rows (0 replies)
  197. Customer accounts balance(debt,credit) vba (0 replies)
  198. email macro stops on Debug Run-time error '91' (1 replies)
  199. Clock not working properly (2 replies)
  200. Email macro works 1 time on excel sheet and stops (1 replies)
  201. VBA Coding help - Multi-page User Form, vlookup, and INTERCEPT (0 replies)
  202. [SOLVED:] Split Cells that have Alt+Enter Text Into Multiple rows and fill rows accrodingly. (8 replies)
  203. Select PivotItems from to... (1 replies)
  204. VBA - Draw line to next high value (3 replies)
  205. Listing rows associated to a value in Col A, by selecting related value in Col B (0 replies)
  206. VBA Macro for taylor Series of Sine (x) (2 replies)
  207. Any suggestion for VB self-learning resources? (0 replies)
  208. [SOLVED:] How to count no of shapes in a group? (2 replies)
  209. VBA code help to sum values in conditionally formated cells (2 replies)
  210. stop incrementing (4 replies)
  211. Automatically increment single cell from 15 to 150 (3 replies)
  212. VBA Code for Searching\Renaming files in a folder (2 replies)
  213. VB Excel, Data Not able to auto refresh (2 replies)
  214. VBA - Finding a value in column A, selecting that row, pasting it above with formulae (4 replies)
  215. dynamic graph based on drop down list (5 replies)
  216. Looping Countifs with Excel Formulas (0 replies)
  217. Automatically pull new data VBA (4 replies)
  218. Filter/sort columns in another sheet (3 replies)
  219. Transpose or Copy Text from text to another Text box and Undo when necessary (0 replies)
  220. [SOLVED:] File not found error when trying to attach PDF to Email (2 replies)
  221. If M column starts with phone number shift K,L and M cells left. (2 replies)
  222. Problem for salary calculation (4 replies)
  223. [SOLVED:] excel vba search text in range and retrieve results in a textbox (3 replies)
  224. [SOLVED:] Type mismatch error on startup (5 replies)
  225. Excel templates to PDF (6 replies)
  226. [SOLVED:] How to compare two Strings and do some find-copy-paste operation (12 replies)
  227. COMBING MACROS (3 replies)
  228. Integer Overflow (11 replies)
  229. [SOLVED:] VBA code to find the string and paste the whole sentence in another cell (2 replies)
  230. [SOLVED:] Copy Paste Ranges - Listed in Column A (6 replies)
  231. [SOLVED:] Show the Solver Dialog Box (3 replies)
  232. Next record problem (3 replies)
  233. How do I save a value from a combobox on a userform to my sheet where ...... (4 replies)
  234. Excel2013 or 2016 on Android Tablet with VBA (3 replies)
  235. Populate spreadsheet cells based on multi select listbox and combo boxes (1 replies)
  236. Retention Report Automation (15 replies)
  237. How to search column and highlight values that are not in dictionary? (9 replies)
  238. Can't copy cells' content into another workbook (0 replies)
  239. [SOLVED:] VB Excel, Count shapes with same color (4 replies)
  240. Inventory System (4 replies)
  241. [SOLVED:] UserForm RowSource Named Range Crashes (5 replies)
  242. Having an Excel file open a website at a specified time (3 replies)
  243. [SOLVED:] Revert Scientific Notiation to the Text that was Entered (9 replies)
  244. [SOLVED:] Finding the active cell in other work book (8 replies)
  245. Msg Box if cell left blank (3 replies)
  246. Sleeper: How to setup clock as per zones, macro should work when excel is open (11 replies)
  247. [SOLVED:] Need help to transform one spreadsheet into another form of spreadsheet. (18 replies)
  248. paste as text from other applications (3 replies)
  249. VBA Error 91 (4 replies)
  250. Copy one cell of a worksheet of a workbook and paste to a master workbook many times (1 replies)