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. Unexpected "Subscription out of range" error (3 replies)
  2. Get last row of a page (13 replies)
  3. Solved: Getting average of a range within a loop (11 replies)
  4. HELP, user-defined type not defined (5 replies)
  5. PIVOT table - Change sub column label (4 replies)
  6. Solved: countif? within a loop (12 replies)
  7. Get HTML Code into String from Newly clicked webpage (i.e. URL doesn't change) (3 replies)
  8. Help with Sorting by first name (28 replies)
  9. Solved: Insert header rows (14 replies)
  10. Solved: New procedure at end of code? (3 replies)
  11. Using HLookup (2 replies)
  12. Macro to fill values of row numbers in a 10x20 grid (2 replies)
  13. Simple VBA Statement (3 replies)
  14. how to get profit as per fifo method (1 replies)
  15. repeated user input (1 replies)
  16. ContextMenu example errors (3 replies)
  17. code created text box not firing change event (12 replies)
  18. Solved: VBA Pogress Bar (2 replies)
  19. Solved: Empty Cells Will Not Delete (2 replies)
  20. Solved: copy from excel to word unmerged table (13 replies)
  21. VBA Form that uses data from a worksheet (2 replies)
  22. Save As Query (5 replies)
  23. Class Modules in AddIn .xlam (14 replies)
  24. Solved: Smallest 3 numbers in range (4 replies)
  25. Paste special data till last updated row (4 replies)
  26. Solved: Application or object based error (3 replies)
  27. [SOLVED:] search folder structure and return paths only (2 replies)
  28. Solved: Refresh my pivot table (4 replies)
  29. Solved: Make folder path and file name with VBA code (2 replies)
  30. Consolidate data from different excel files (VBA) (9 replies)
  31. Help with code to copy to another worksheet (0 replies)
  32. Solved: Getwindowstext and settext (4 replies)
  33. Compile error: Expected line number or label or statement or end of statement? (0 replies)
  34. Merseene Twister VBA app easy issue to solve (with zip file) (0 replies)
  35. Solved: EASY VBA ISSUE TO FINALIZE THE IMPLEMENTATION OF THE MERSEENE TWISTER RNG (19 replies)
  36. Embedded gif in userform (6 replies)
  37. Solved: Use a spreadsheet specifies interval even if another is active (2 replies)
  38. Remove gaps in a combobox list (3 replies)
  39. Muti Solver VBA (0 replies)
  40. RunTime error 462 - The remote Server machine does not exist. (0 replies)
  41. Line list box (0 replies)
  42. conditional formatting text conditions (2 replies)
  43. Text Box, text formatting (0 replies)
  44. execute macro if change to range (2 replies)
  45. CONDITIONAL FORMULA with Percentage (2 replies)
  46. VBA Show All Data (6 replies)
  47. Solved: Sort All sheets in a workbook (4 replies)
  48. Capture window help (1 replies)
  49. data send to zohosheet (0 replies)
  50. pivot vba (0 replies)
  51. VBA Excel HTML e-mail? (4 replies)
  52. [SOLVED:] Excel chart - identify the selected data point through macro. (5 replies)
  53. Opening a new file of a different format (2 replies)
  54. Multiple conditional values from Excel in VBA listbox (0 replies)
  55. Excel vba script to insert data into Outlook (1 replies)
  56. datestamp on cell CHANGE (3 replies)
  57. OFFSET of result from vlookup (8 replies)
  58. Runtime err 1004 (0 replies)
  59. Running Macro Automatically if a cell value is True. (2 replies)
  60. Export Selected Sheets to New workbook (0 replies)
  61. VBA - Macro to create/update documents in Lotus Notes database (1 replies)
  62. Solved: cell checking (2 replies)
  63. Attachment to gmail (3 replies)
  64. Solved: Function that's not working as should (5 replies)
  65. Solved: change name tab office (4 replies)
  66. Disappearing calc field in pivot table (9 replies)
  67. Special Sort needed - Sorting labels contained in one column (4 replies)
  68. group and hide blank space (1 replies)
  69. Multiple Criteria Lookup (1 replies)
  70. Solved: Type mismatch error on If Not Range... (8 replies)
  71. Solved: user name (4 replies)
  72. vba to find and replace exact matches of cell value in a sheet (3 replies)
  73. Solved: sort columns dynamic (13 replies)
  74. Solved: Add third column to listbox (6 replies)
  75. VBA - CELL VALUES EXCEED 12 (MONTHS) (4 replies)
  76. Multiple currency format from UserForm (9 replies)
  77. Can not get rid of "Do you want to Save changes" (1 replies)
  78. Use a list from Excel to move files on computer (5 replies)
  79. Solved: Double Click Event for Shapes (16 replies)
  80. Excel Automation of IE - help click this button (5 replies)
  81. Solved: Byref argument type mismatch array (6 replies)
  82. Solved: Remove Freeze Panes From Inactive Window (4 replies)
  83. Solved: Return a value from another sheet (3 replies)
  84. Solved: Worksheet Change Function: Created WS? (4 replies)
  85. Solved: Excel- align rows by column. Works but too slow! (2 replies)
  86. Solved: Help with automatically fill in cells by VBA loops (0 replies)
  87. Solved: Add date to Userform (4 replies)
  88. How to get records in excel ADO (1 replies)
  89. Problem Using Kill File (5 replies)
  90. Solved: Incorrect VBA Sort on Workbook Close (6 replies)
  91. Solved: Help with Find/Delete Entire Row (3 replies)
  92. Solved: Draw without repeating words until the entire list has been drawn (6 replies)
  93. Solved: If cell is cleared or blank the conditional formating color is removed (2 replies)
  94. Solved: Subfolders's names in array (2 replies)
  95. Solved: VBA to delete a row in another worksheet (0 replies)
  96. An MSForms Treeview (0 replies)
  97. Solved: Repeat cells N Times (2 replies)
  98. Removing Spaces (2 replies)
  99. Summarising of info from many w/sheets with a Macro (1 replies)
  100. Excel macro/VBA to sort a column, upload to sharepoint and save as draft on outlook (0 replies)
  101. Copy worksheet cells from sub folders to new workbook (2 replies)
  102. using excel to fill online form (2 replies)
  103. Solved: Loop Until Help (0 replies)
  104. Solved: Copy data with values & paste in another worksheet (4 replies)
  105. Extract Web Page Data (2 replies)
  106. [SOLVED:] Need help for conversion (9 replies)
  107. Date Time copy paste not including time (2 replies)
  108. reload job nos fron jobs at J status (0 replies)
  109. Test if variable or object exists (4 replies)
  110. New Workbook for each worksheet (7 replies)
  111. Resize Chart as Picture (8 replies)
  112. Solved: Used Range Selective ClearFormat (11 replies)
  113. Link UserForm with worksheet data (1 replies)
  114. Excel DLL CUDA (1 replies)
  115. VBA FORCE CELL NOT WORKING (3 replies)
  116. Solved: VBA Code : Help required (4 replies)
  117. mail from excel (1 replies)
  118. [SLEEPER:] Context Menu on UserForm (18 replies)
  119. CostCenter and Product combinations (6 replies)
  120. Double click can edition in ListView (0 replies)
  121. Display tiff image on vba form (6 replies)
  122. Solved: .FormulaR1C1 VBA (4 replies)
  123. Extract Values of SN tags and save to Excel (2 replies)
  124. dynamic x axis "find last cell" vba code (3 replies)
  125. Simulate mouse movements (4 replies)
  126. Worksheet_SelectionChange(ByVal Target As Range) (22 replies)
  127. VBA CODE ADD TO CODE MANDATORY CELL (4 replies)
  128. Solved: Macro to remove entire if null value encounter in column (1 replies)
  129. Auto Start/Stop Macro at specific times (4 replies)
  130. Re arrange columns from selected rows (3 replies)
  131. Solved: placing formula in the same cell (D7) of all tabs (10 replies)
  132. Is querying beyond 255 columns dead? (2 replies)
  133. Solved: Create chart on new sheet using VBA (2 replies)
  134. Solved: separate specific symbols in order of priority (2 replies)
  135. Solved: Hex to Binary conversion, not using HEX2BIN (9 replies)
  136. Solved: Help uderstanding this loop (1 replies)
  137. for loop returning 2 numbers (1 replies)
  138. Export worksheet problem with path (1 replies)
  139. Solved: Copy a Range then Transpose Paste into every other Cell (5 replies)
  140. Solved: Copy and Paste On Formula Result (10 replies)
  141. Remove Last Row Value From Sort (4 replies)
  142. Help with multiple criteria functions or VBA code. (0 replies)
  143. Help with a macro (3 replies)
  144. Solved: Range.Find returning Nothing (12 replies)
  145. If any column in active worksheet is hidden, then the value of cell A1 is “hide”. (2 replies)
  146. Solved: Is there a way of shortening my ever increasing vba (14 replies)
  147. Code to Compare Cell Contents (0 replies)
  148. I need a Worksheet_Change macro moving cell to cell (7 replies)
  149. Asking about VBA in Excel (1 replies)
  150. Save dialog in ppt (1 replies)
  151. Solved: Multiple IF statement (??) (5 replies)
  152. Linking macros to hyperlinks in VB (8 replies)
  153. Refernce formula and formatting (1 replies)
  154. RunTimeerror 2147417848 (80010108) Object invoked disconnected from its clients (15 replies)
  155. Formatting strings in cells (2 replies)
  156. Solved: Find Text (2 replies)
  157. How to call\use DLL via vba macro? (7 replies)
  158. Solved: long function from excel to vba (7 replies)
  159. How to sort files before inserting to worksheet (1 replies)
  160. Solved: Date, Month, and Time Stamp using VBA (5 replies)
  161. Help to a code - Save as - Debug (11 replies)
  162. Need help with select case structure (3 replies)
  163. VLOOKUP Between workbooks (1 replies)
  164. microsoft ado control & datagrid6 (4 replies)
  165. Solved: Excel 2003 Saveas Issue (5 replies)
  166. Dynamic Range Transpose Loop (3 replies)
  167. Using VBA to disable Save and Save As (1 replies)
  168. How to insert Japanese character to SAP from Excel? (10 replies)
  169. Delteing (1 replies)
  170. VBA lookup and delte (1 replies)
  171. VBA HELP (2 replies)
  172. Copy function (2 replies)
  173. Solved: Time Stamp in cells using VBA (4 replies)
  174. VBA Code to Hide Blanks in Pivot Table (1 replies)
  175. Solved: Running Module from Other Workbook (8 replies)
  176. HELP to show formula (3 replies)
  177. Solved: Cant get the value of a control in a multipage (3 replies)
  178. Solved: Importing data from other Excel spreadsheets (14 replies)
  179. Solved: Need help regarding formatting sting using VBA (2 replies)
  180. Function, compile error. (5 replies)
  181. Need help to insert column in Pivot (3 replies)
  182. Solved: My code start to be slow. (3 replies)
  183. Add user edit range (3 replies)
  184. Solved: launching a shell command silently from within VBA (10 replies)
  185. [SOLVED:] Move the mouse cursor in the top left corner of the selected cell. (4 replies)
  186. Allowing user to select range of columns for comparison (2 replies)
  187. Errors all over the place!!! (13 replies)
  188. Check Word, Powerpoint and Excel files for embedded objects (6 replies)
  189. Subract last cell from above (1 replies)
  190. Macro/VBA Beginner-HELP!! (1 replies)
  191. Hide the form on a worksheet (2 replies)
  192. Find, Copy Text from Word and paste in excel (4 replies)
  193. Solved: Excell crashing for apparently no good reason (18 replies)
  194. Solved: Delete Cell Content based on criteria (7 replies)
  195. Need help in collating data from multiple excel files (3 replies)
  196. Splitting data in a cell to multiple (2 replies)
  197. [SOLVED:] Popup when calling function (5 replies)
  198. Some fun with message box???? (4 replies)
  199. Consolidate Worksheets(and new added sheets) into 1 Worksheet+sum by date & customer (0 replies)
  200. ELSE without IF error (5 replies)
  201. Macro not working in Excel2013 (15 replies)
  202. Change object properties for previously created objects (4 replies)
  203. Calculation Speed (4 replies)
  204. Excel / VBA Left Function (Fine-tuning) (1 replies)
  205. [SOLVED:] Solved: force pastespecial values (6 replies)
  206. VBA to auto-remove missing Refernces (2 replies)
  207. Userform label Text link... (0 replies)
  208. Solved: Autofill column with the values from next column ...etc (14 replies)
  209. Forcing input format for dates? (6 replies)
  210. Setting the Name for a Dynamic UserForm (1 replies)
  211. find large numbers and delete (2 replies)
  212. Automate a process to run every hour (0 replies)
  213. Solved: Pie chart series rotation (2 replies)
  214. VBA Excel - PPT loses textbox at Slides.Add ! (0 replies)
  215. How to apply a Formula in a whole column... (3 replies)
  216. Excel 2013 Compatibility (1 replies)
  217. Solved: Using Formulas matrix in VBA and drag down (12 replies)
  218. Solved: Reloading a combobox with found data (10 replies)
  219. Import text file format to excel difficulty (2 replies)
  220. Excel 2007 - Change Default Format Data Labels Option (0 replies)
  221. Solved: Need a quick Indirect() reference (4 replies)
  222. Excel Asking for DSN (0 replies)
  223. Solved: VBA Delete Error 400 (3 replies)
  224. Solved: Sort Macro (4 replies)
  225. Shape Selection Dynamically (3 replies)
  226. [SOLVED:] Write-Once only rights (8 replies)
  227. Repeat Rows at Bottom of Worksheet (0 replies)
  228. UserForm Caption text with a cell ... (3 replies)
  229. VBA PASSING VARIABLE (3 replies)
  230. Solved: Hide UserForm & Stop Closing Excel (10 replies)
  231. Run-time error '1004 Application-defined or object-defined error (1 replies)
  232. Item Property of Files Collection (13 replies)
  233. Excel Macro (2 replies)
  234. Showing Sheet content in WebBrowser control (0 replies)
  235. Solved: Icon software (4 replies)
  236. [SOLVED:] Macro to copy cells in column G & H if cells in col K & L are blank (3 replies)
  237. Solved: Find value in column "A" on one tab to another tab and replace the value in column "B (13 replies)
  238. VBA Autosort Exclude Text Value (3 replies)
  239. Need to copy part of active spreadsheet and save to desktop (1 replies)
  240. Solved: subscript out of range (4 replies)
  241. Solved: Incorporate VBA With Copy and Paste (2 replies)
  242. SolverAdd ignores certain constraints (1 replies)
  243. Solved: .Application.Visible = False (10 replies)
  244. I Need vba code clear cells (6 replies)
  245. Lock Column Cells If Cell Equals (2 replies)
  246. Regression (1 replies)
  247. Solved: VBA Sort (4 replies)
  248. Sum a range with values & blanks then paste product into a cell (7 replies)
  249. Match and copy, unique condition (21 replies)
  250. Solved: Copy column and paste into rows (6 replies)