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 174
  1. [SOLVED:] VLOOKUP Problem (duplicating lines) (10 replies)
  2. [SOLVED:] Return Column / Row name of active cell (6 replies)
  3. [SOLVED:] Macro recording gives different result in graph (6 replies)
  4. [SOLVED:] referencing a control type (3 replies)
  5. [SOLVED:] Selecting userform from cell content (1 replies)
  6. [SOLVED:] Anyone know how to - Range = typed array (22 replies)
  7. VBA to force paste special (19 replies)
  8. [SOLVED:] VBA open password protected file in read only mode (3 replies)
  9. how to grab filter list data (2 replies)
  10. Quick question about my code that creates a 2D array (11 replies)
  11. Tweak VBA to Move SharePoint Files to a Folder in Same Location (5 replies)
  12. Copying formulas from 2 different workbooks (0 replies)
  13. VBA Reference problem (4 replies)
  14. [SOLVED:] Using stdev() function in VBA (2 replies)
  15. Help with activating sheets (3 replies)
  16. Running a macro when double clicking a cell in another sheet (1 replies)
  17. Write formula in VBA-'Error 13' (4 replies)
  18. [SOLVED:] Error 1004 Application defined or object defined when code runs (3 replies)
  19. [SOLVED:] Help with syntax for nested dictionaries (8 replies)
  20. Macro/VBA code help (9 replies)
  21. Evaluate 3 columns of data and display 1 value in a 4th column (3 replies)
  22. Create Button Shadow Effect (7 replies)
  23. [SOLVED:] VBA issue with renaming a file (8 replies)
  24. Macros for saving the file with sertain file name (2 replies)
  25. [SOLVED:] prevent form to make the sheet scroll? (7 replies)
  26. Check if a text box exists in a webpage and if so then run code. (4 replies)
  27. [SOLVED:] Using VBA in Excel 2010, need to change text of many cond formats, but how? (4 replies)
  28. Replace Query Database (5 replies)
  29. [SOLVED:] Create sub lists from main list (5 replies)
  30. Next loop without calling additional functions on error (4 replies)
  31. Sleeper: Adding a subroutine to a macro already done. (1 replies)
  32. [SOLVED:] Conditional percentile calculation (2 replies)
  33. Re-Enabling Cut/Copy/Paste on Excel (3 replies)
  34. Is it possible to run code every 24th hour for 3 days? (5 replies)
  35. Run code every 24th hour for three days - fx? (0 replies)
  36. İf cell contains the number then copy certain cells to another book (5 replies)
  37. [SOLVED:] Userform with doubleclick filled with values of autofilter (4 replies)
  38. [SOLVED:] VBA code to track changes in workbook (14 replies)
  39. VBA code not finding values that contain numbers and letters....HELP! (12 replies)
  40. Find maximum number of rows with text, then fill accordingly (6 replies)
  41. VBA code required to unhide multiple sheets (5 replies)
  42. [SOLVED:] Help with array printing (4 replies)
  43. [SOLVED:] VB to search for a key word in Column A, then copy it to column B for multiple rows. (3 replies)
  44. Put text in multiple cells (3 replies)
  45. [SLEEPER:] Error 1004 (1 replies)
  46. Help me tweak working VBA Code (4 replies)
  47. [SOLVED:] Problem with Print All Sheets (4 replies)
  48. Calculation on matrix using formula (0 replies)
  49. [SOLVED:] Copy cells from password protected (to open) workbook into another file (2 replies)
  50. Traffic lights - Increasing/Decreasing Trends (3 replies)
  51. First 6 minimum values of a row in an array (5 replies)
  52. [SOLVED:] How to list all the files in a folder? (2 replies)
  53. [SOLVED:] VBA Code for Combining Multiple Columns into One Column - Excel for Mac (3 replies)
  54. [SOLVED:] Excel VBA to copy cells from password protected file into another file (12 replies)
  55. Extracting data, pivot tables, and maybe VBA help? (10 replies)
  56. Custom Data Type - Dim Variable As CustomDataTypeName (4 replies)
  57. My greeting macro doesn't run automatically when I open Excel (3 replies)
  58. [SOLVED:] WorksheetFunction.HLookUP 1004 Error (7 replies)
  59. [SOLVED:] Excel VBA to open a workbook that contains a string (1 replies)
  60. Run Macro Save AS (4 replies)
  61. [SOLVED:] Macro Button (3 replies)
  62. [SOLVED:] insert name of tabs that had data copied in master tab (5 replies)
  63. [SOLVED:] Getting values off another sheet by references!? (2 replies)
  64. Help with Data copy from IE to Excel (0 replies)
  65. Create appointments on a shared Outlook calendar from Excel (3 replies)
  66. Sleeper: Scaling chart based on values (1 replies)
  67. [SOLVED:] Getting values from merged cells (1 replies)
  68. Max Frequency (1 replies)
  69. [SOLVED:] UF Run Macro if LEN equals a number (3 replies)
  70. Assigning Headers (5 replies)
  71. VBA Get Data Java (0 replies)
  72. VBC to highlight / select group of active cell (3 replies)
  73. What does '400' mean? (4 replies)
  74. conditioned comboboxes (2 replies)
  75. Find and replace words that are formatted with tags (3 replies)
  76. [SOLVED:] Serious trouble with running total calculations (12 replies)
  77. ActiveWorkbook vs Application.Workbooks (2 replies)
  78. How to updated pivot tables on different tabs from user form parameters? (37 replies)
  79. Activating multiple sheets with countifs function (4 replies)
  80. [SOLVED:] Extracting values from sheet 1 to sheet 2 (5 replies)
  81. Source code - Cant find something that ought to be there (1 replies)
  82. Pivot data Filter VBA Code require (0 replies)
  83. How do you extract only specific FormFields from multiple Word documents into Excel? (4 replies)
  84. Creating a master tracker to copy worksheets and perform tasks (10 replies)
  85. [SOLVED:] Workbooks object question (2 replies)
  86. [SOLVED:] error when vba editor opens by code 'not trusted' (0 replies)
  87. VBA macro code to find and replace values in XMLfiles using Excel list (0 replies)
  88. [SOLVED:] Bypassing a dialog box (2 replies)
  89. [SOLVED:] UF ComboBox Populate from Sheet (3 replies)
  90. VBA Dynamic Start Rows (10 replies)
  91. Help for using MID and INSTR in source code! (3 replies)
  92. Error 424: what am I missing? (3 replies)
  93. [SOLVED:] Splitting the content of a cell based on special characters (2 replies)
  94. delete rows based on search criteria (1 replies)
  95. [SOLVED:] Working with "selection" instead of precise address= slow as a snail (5 replies)
  96. [SOLVED:] Sub or Function not defined (10 replies)
  97. [SOLVED:] How do I update multiple worksheets based on one userform? (3 replies)
  98. Combine Columns from different worksheets into one (2 replies)
  99. [SOLVED:] Make one loop with dynamic range (Find Last Cell) (9 replies)
  100. [SOLVED:] Wronf priority of events? picture in form not showing because heavy processing (2 replies)
  101. Error bars on charts (1 replies)
  102. Print Results To Excel Worksheet (6 replies)
  103. Shared Workbooks - against all odds... (2 replies)
  104. Macro update to copy data from sheet 1,2,3 into same sheet (1 replies)
  105. [SOLVED:] Making multiple files. (4 replies)
  106. [SOLVED:] ByRef argument type mismatch (2 replies)
  107. [SOLVED:] vba conditional formatting (1 replies)
  108. i want required vba. I am looking for a small value from the Range (4 replies)
  109. [SOLVED:] unmerge all cells a workbook from another workbook (3 replies)
  110. Can't locate bug of a Run-time error '438' message (3 replies)
  111. [SOLVED:] Run time error 52 - bad file name or number (1 replies)
  112. AverageIF function (5 replies)
  113. [SOLVED:] VBA: Export Certain sheets of a workbook as PDFs (2 replies)
  114. Deleting Rows That contain specific content in two columns (1 replies)
  115. [SOLVED:] No rush, just to improve myself (3 replies)
  116. Send SMS from Excel VAB from API (2 replies)
  117. Compare cells with one value against cells with two values then merge and count (6 replies)
  118. countifs in the VBA (3 replies)
  119. web extraction (3 replies)
  120. Runtime Error 9 Help (3 replies)
  121. What should be the VBA code for this output (2 replies)
  122. Data set analysis (0 replies)
  123. Updating Links on networked spreadsheet (0 replies)
  124. how to skip a VBA code if it already exist - Rename worksheet (1 replies)
  125. Action to cells in a specific column of selected rows (2 replies)
  126. Searching for a string and move it's data to different sheets (8 replies)
  127. Disable "Save" & "SaveAs" (4 replies)
  128. After mail merge code want save as box for Word doc (8 replies)
  129. [SOLVED:] Looping Through Calculations (6 replies)
  130. Need Help: Changing Date Formatting, Filter Unique Value, Sort (1 replies)
  131. VBA assistance required for copy values (2 replies)
  132. [SOLVED:] Problem Copying two Sheets from one workbook to another workbook (2 replies)
  133. VBA Type Mismatch Error on Pivot Table Creation (5 replies)
  134. [SOLVED:] ActiveCell.Offset(1, 0).Range("A1").Select? (1 replies)
  135. Syntax to selecting multiple columns/particular column with its contents in Excel VBA (4 replies)
  136. [SLEEPER:] Opening a word document (5 replies)
  137. Getting 1004 Error from sorting a range and cannot figure out why. (3 replies)
  138. Excel VBA user form (3 replies)
  139. VBA help: Copy, offset, add cells, repeat, all on one button? (6 replies)
  140. VBA Creates Pivot Table Except when Row 1 is blank (5 replies)
  141. allocating the totals - to numbers equally (11 replies)
  142. User must fill in certain cells before they can close the workbook (5 replies)
  143. Help sorting data (7 replies)
  144. Macros - Upgrading from Excel 2003 to Excel 2010 (5 replies)
  145. Validation Of Names Required from given List :confused (5 replies)
  146. Recognizing linked changes, Worksheet_Change(ByVal Target As Range) (1 replies)
  147. [SOLVED:] Pivot table not showing the selected items when filter added (4 replies)
  148. Moving duplicate and unique values from one sheet to another. (0 replies)
  149. How can I fill Database with VBA on Mac? (0 replies)
  150. Printing Visible Data Only (3 replies)
  151. [SOLVED:] What did I miss? (get constant value from the string text) (8 replies)
  152. VBA Match & Copy (2 replies)
  153. Remove Duplicate macro, modify to delete adjacent cell (8 replies)
  154. How to save each change in list in new workbook (4 replies)
  155. Sleeper: VBA for Page Headers (1 replies)
  156. Combine data from many worksheet into one worksheet (1 replies)
  157. [SOLVED:] Summing of multiple totals. (2 replies)
  158. [SOLVED:] Combi Box disappearing from the screen. (3 replies)
  159. [SOLVED:] Showing help on object elements from a form? (2 replies)
  160. Excel vba copy paste with formulas (2 replies)
  161. Various items - exporting to various .txt files where duplicates (5 replies)
  162. [SOLVED:] VBA Sorting multiple rows (4 replies)
  163. [SOLVED:] VBA - Determine cell value of specific column and row in userform (2 replies)
  164. help me please (15 replies)
  165. sortind dates (2 replies)
  166. Need a VBA coding (5 replies)
  167. [SOLVED:] Optimizing VBA code so that it can execute on a workbook of 50,000 rows w/o crashing (11 replies)
  168. NEED CORRECTION IN MACRO (5 replies)
  169. Excel vba jump to specific row in worksheet (2 replies)
  170. HELP: How to format certain texts enclosed by specific characters (7 replies)
  171. Create individual folders for next day (4 replies)
  172. Syntax to identify if something does NOT match a Wildcard? (7 replies)
  173. [SOLVED:] Clear worksheets from list (7 replies)
  174. Need help with VBA passing an argument (47 replies)
  175. use arrow in vba formula? (2 replies)
  176. Run time Error on Save Data (6 replies)
  177. Find 2 identical values in 2 columns - looking for error message (1 replies)
  178. [SOLVED:] How to search values in external workbook and pull out information from the same line (31 replies)
  179. [SOLVED:] Referencing a subset of text within a cell (9 replies)
  180. [SOLVED:] Clean the row if column B to O is empty (3 replies)
  181. VBA - Excel/Word 2007 - Using excel to compile a report in word (12 replies)
  182. [SLEEPER:] Enable Maximize button and change userform size by manually dragging borders. VBA (2 replies)
  183. Macro to sum between headers (2 replies)
  184. Insert data inside filed form in WEB (1 replies)
  185. [SOLVED:] trouble viewing code (0 replies)
  186. Any 64-bit Office users? (4 replies)
  187. VBA Code Cannot Access Database In SQL Server (9 replies)
  188. [SOLVED:] Current Code works, then when I add a line, Excel Crashes (4 replies)
  189. [SOLVED:] How to produce two workbooks from a larger workbook (7 replies)
  190. How To Create Macro To Pull Tables From SQL Server (2 replies)
  191. search rows in VBA (1 replies)
  192. [SOLVED:] If Condition returns Formula (3 replies)
  193. [SOLVED:] eliminate question mark box when enter key is pressed (20 replies)
  194. [SLEEPER:] Create a Stopwatch for time study (3 replies)
  195. Export Excel 2010 to Project 2010 VBA adding columns to Project (5 replies)
  196. Excel - Send sheet & use range as body (2 replies)
  197. Vlookup through VBA: Dynamic Range (10 replies)
  198. Automated Data import from website (1 replies)
  199. [SOLVED:] KB: Group All Command Buttons on a Userform (12 replies)
  200. Calendar not linking to Userforms. (2 replies)
  201. [SOLVED:] Find and replace macro bugging out with finding #VALUE! (1 replies)
  202. [SOLVED:] Loop in VBA (2 replies)
  203. Linking numerical value occurrence to a date (2 replies)
  204. Return data from different sheets and variated cells Macro (3 replies)
  205. [SOLVED:] Copying to another sheet. (5 replies)
  206. VBA - importing all excel files in subfolders (1 replies)
  207. Match words in 2 cells (1 replies)
  208. can anyone see an isue with this line? object defined error (6 replies)
  209. [SOLVED:] Show in Label value in cell specific column (everey minute) (5 replies)
  210. Enlarge and restore an embedded chart from a group of charts (2 replies)
  211. [SOLVED:] Summing of sheets macro needed. (8 replies)
  212. Table of content or Hyperlink for different Table Name in work-book (3 replies)
  213. Halp! Excel data exporting (5 replies)
  214. [SOLVED:] Time/Date Formula for Analysis (3 replies)
  215. Tracking old & new formula changes & other changes w/ links to original cells (1 replies)
  216. Update variabel to be = string, specified in a cell?(Splitting a cell and distribute) (2 replies)
  217. Weather Forecast Spreadsheet User Form Help (3 replies)
  218. Used Opentext command, - How do i select the pop-up Workbook? (5 replies)
  219. scrape excel sheet embedded in an intranet page (3 replies)
  220. CountIf Help (3 replies)
  221. Runtime error 462 (1 replies)
  222. MacBook Pro Comparison (3 replies)
  223. [SOLVED:] How to enable macro (5 replies)
  224. Save as user form (1 replies)
  225. Problem solved - sorry (0 replies)
  226. VBA - the lowest number not working (2 replies)
  227. Macro Keeps changing date to American format (16 replies)
  228. Default Cumulative Cost Curve (VBA) (1 replies)
  229. Hi (1 replies)
  230. Creating letters quicker from spreadsheet (9 replies)
  231. Modifying excel data through VBA (1 replies)
  232. Setting column number and row number to variables leads to lots of issues (1 replies)
  233. [SOLVED:] Macro to compile a list in another workbook (5 replies)
  234. [SOLVED:] SendKeys really working (9 replies)
  235. [SOLVED:] Cell formating (3 replies)
  236. [SLEEPER:] Send Macro cell rang as attachment to outlook with default signature (5 replies)
  237. How to add alternate column in worksheet (2 replies)
  238. Formula won't work past a certain date (4 replies)
  239. #Value error msg in VBA code (5 replies)
  240. Search a table on a website for a word & extract the 3rd cell to the Right of it. (8 replies)
  241. [SOLVED:] Fast compare values of Non-Contiguous Cells row in two different workbooks (3 replies)
  242. VBA code required:Compare sheet1 with sheet2 and copy the difference (1 replies)
  243. keyboard shortcut to copy the url of a cell (4 replies)
  244. VBA, retreive information from a word document and store it in the Excel (1 replies)
  245. [SOLVED:] Range selection fail when integrating with PowerPoint (3 replies)
  246. [SLEEPER:] Macro to save in txt format web pages (1 replies)
  247. Access different tabs in Excel forms (12 replies)
  248. [SOLVED:] Identifying mixed Managers (3 replies)
  249. [SOLVED:] is sheet selection by variable possible? (2 replies)
  250. VBA help loop search and check status of item (2 replies)