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. xlsm file opens and immediately closes (7 replies)
  2. VBA for designing your sheet (2 replies)
  3. Replace text in email body from the excel (1 replies)
  4. Array match Only 1 RedimPreserve (7 replies)
  5. Find empty cell in one spreadsheet and then paste information from another (1 replies)
  6. [SOLVED:] Array of Email Addresses (8 replies)
  7. Type missmatch error (5 replies)
  8. [SOLVED:] MS MapPoint and MS Excel, plot latitude and longitude on a map (11 replies)
  9. Restoring default Styles in Excel (4 replies)
  10. [SOLVED:] Showing two expected values together with an IF function (2 replies)
  11. [SOLVED:] Color cells from previous colored cells in different column (0 replies)
  12. VBA to copy a new sheet based on active sheet (11 replies)
  13. INDEX MATCH in VBA over different data files (3 replies)
  14. [SOLVED:] Split Cells into rows but with two columns (10 replies)
  15. VBA - Set data list (8 replies)
  16. How to speed up VBA Code (12 replies)
  17. [SOLVED:] Help to faster this script for moving Duplicates (4 replies)
  18. How to Merge Cells Specially (12 replies)
  19. it is possible to save individual sheets as a separate file? (9 replies)
  20. [SOLVED:] VBA-split data into multiple worksheets based on column (6 replies)
  21. Outlook vba help - Folder Picker (0 replies)
  22. It is possible deleting rows in lisboxt datagrid with active sheets displayed vba exc (13 replies)
  23. [SOLVED:] Validation Code Problem (6 replies)
  24. Performing count and max commands on multiple groups of rows (2 replies)
  25. [SOLVED:] Arrangement of values in groups (3 replies)
  26. [SOLVED:] Excel 2010 run time error 91': Object variable or with block ... (8 replies)
  27. Filter the entries of Combobox (7 replies)
  28. [SOLVED:] Error Handling (runtime error 1004) (13 replies)
  29. Need help moving many fields of data from the master sheet to several other sheets (4 replies)
  30. [SLEEPER:] How to get data from an array table with two different values (0 replies)
  31. [SOLVED:] Concatenation with double quotes and comma for the selected list of values (17 replies)
  32. VBA_Pivot table capture in array and reapply (1 replies)
  33. search for multiple value using FORMS (0 replies)
  34. Returning the Caption Property for active controls in an email body (11 replies)
  35. [SOLVED:] Getting Run Time Error 5 on String? (10 replies)
  36. Improve efficiency of VBA Code (16 replies)
  37. [SOLVED:] Validate cells in column A with info from other columns (12 replies)
  38. what is wrong with my update button code excel vba (6 replies)
  39. Vlook from Closed workbook taking a lot time (4 replies)
  40. copy and paste a certain number of times (2 replies)
  41. [SLEEPER:] Loading a txt file into excel win works fine. Loading txt on a mac doesn't work. (1 replies)
  42. [SLEEPER:] my excel vba stop running when i run the userform and not responding (37 replies)
  43. macro to send multiple emails with all attachements from specific folder (2 replies)
  44. [SOLVED:] Create outlook appointementes only on "check" rows (1 replies)
  45. Need help with Timesheet Workbook I know exactly what I need ! (6 replies)
  46. [SOLVED:] Return Multiple Listbox Selection (12 replies)
  47. Extract single row from multiple workbooks (2 replies)
  48. Sheet_change is not worked (5 replies)
  49. Combine Data in Mutiple Columns into Rows (2 replies)
  50. Loop for substitution (1 replies)
  51. [SOLVED:] Loop to copy and paste first cell of repeated values (14 replies)
  52. Copy data from multiple single-worksheet workbooks into another workbook (1 replies)
  53. [SOLVED:] Sum Values Assigned to a Name (3 replies)
  54. [SOLVED:] automated data query (1 replies)
  55. [SOLVED:] Remove duplicates (runtime error 5) (1 replies)
  56. [SOLVED:] Dim problem (4 replies)
  57. VBA Code running in f8 but not f5 (2 replies)
  58. [SOLVED:] Range of inputs and graphing of result (8 replies)
  59. What am I doing wrong here? (11 replies)
  60. [SOLVED:] how to loop search to show multiple entries in listbox (8 replies)
  61. Minimize-Maximize-Resizing-Scrolling in a Userform (1 replies)
  62. VBA Code to attach (multiple) file(s) (7 replies)
  63. [SOLVED:] lookup formula to sum percent (2 replies)
  64. VBA Code problem for Excel 2016 on a mac (5 replies)
  65. [SOLVED:] Loop through all Pivot tables in a worksheet and filter visability VBA (4 replies)
  66. [SOLVED:] Looping through a Range of Data (3 replies)
  67. Dsum and Data Tables (3 replies)
  68. Avoid code repetition by calling the common code from another sub (6 replies)
  69. Finding the last modified date of an excel sheet (15 replies)
  70. [SOLVED:] Split First, Middle and Last Name (20 replies)
  71. Save Active Word Doc with URL File Path (14 replies)
  72. Iterate 2 dropdown lists and move to all the new tabs to new workbook (0 replies)
  73. [VBA] set range find() -> finds wrong value (4 replies)
  74. [SOLVED:] Using concatenate to reference a named range (3 replies)
  75. VBA event to detect an Autofill Scrolling? (3 replies)
  76. Paste column format only through iteration (4 replies)
  77. Office Automation: Excel executng Word VBA (14 replies)
  78. Pull Date by Criteria for Visible cells only (1 replies)
  79. [SOLVED:] Line Break Validation (6 replies)
  80. vba - copy workbook 300 times once user selects folder (0 replies)
  81. [SOLVED:] Copy row data from one workbook to another based on row header name (10 replies)
  82. ID matching with Name and sub six hours work time calculation (1 replies)
  83. Mail Merge Excel however instead of Print Need save as (8 replies)
  84. email automation (2 replies)
  85. help creating a repricing tool with defined parameters (5 replies)
  86. Excel charts as jpgs to specific powerpoint (3 replies)
  87. VBA To search for a WorksheetSheet and a Column in that sheet. (2 replies)
  88. [SOLVED:] Outcome is not as expected - code might be wrong (22 replies)
  89. [SOLVED:] Non Regular Sequential Numbering (5 replies)
  90. [SOLVED:] Why are my formulas changing automatically? (3 replies)
  91. [SOLVED:] Issue with button (4 replies)
  92. [SOLVED:] listbox1 to listbox2 (3 replies)
  93. [SOLVED:] COUNTIF code then insert copied cells (4 replies)
  94. Import HTML Data into excel (2 replies)
  95. How to rename a bunch of files in the same folder using an Excel VBA code? (6 replies)
  96. Control Panel using a userfom and hide workbook (3 replies)
  97. [SOLVED:] Returning an element from an array of subclasses (2 replies)
  98. [SOLVED:] Convert text in alphanumeric string to lower case (7 replies)
  99. [SOLVED:] Bold First Name in a VBA generated Email (9 replies)
  100. Formatting table in worksheet (4 replies)
  101. Replacing Text evenly from 1 sheet to another sheet (8 replies)
  102. [SOLVED:] loop through files in a folder based on a condition (4 replies)
  103. VBA Combobox for vlookup (1 replies)
  104. [SOLVED:] Wrong result of my macro! (13 replies)
  105. Index/Return cell references from table array based on "Yes"/"No" response (14 replies)
  106. How to consolidate data from multiple sheets into a master excel (5 replies)
  107. Form showing odd sizes (5 replies)
  108. Vba Code to open multiple files from a specific directory (4 replies)
  109. Userfom to count items and show clicks and percentage vs target (3 replies)
  110. Automatic Refresh causing paste issues (6 replies)
  111. Problem With Macro (3 replies)
  112. Copying two ranges and transposing one of them (1 replies)
  113. [SOLVED:] Toggle "select objects" instead of cells ?? (25 replies)
  114. [SOLVED:] Inputbox with date used as European style (1 replies)
  115. Filter quantity of the commodity code from total data and minus decesing ??? (2 replies)
  116. [SOLVED:] Add Unequal Amount of Data To Two Columns of UserForm List Box (6 replies)
  117. Sumif from pivot table (1 replies)
  118. [SOLVED:] Align List Boxes On User Form Using a Loop (2 replies)
  119. Create Power point presentation from multiple excel files (3 replies)
  120. Product List Search Function (3 replies)
  121. File properties using FSO and Dir (19 replies)
  122. Update Another Sheet with Results of Formula w/Multiple Criteria (10 replies)
  123. [SOLVED:] Excel Code Help, Loop related (5 replies)
  124. Getting a Macro in Power Point to skip update if and excel sheet is open (3 replies)
  125. Data transfer depending on the empty cells (4 replies)
  126. [SOLVED:] Fill Userform Text Box From Worksheet (2 replies)
  127. Copy formula/row range down to a value specified by another cell? (4 replies)
  128. VBA - Email notification when job added to list. (15 replies)
  129. [SOLVED:] Copy data from rows to other worksheets (2 replies)
  130. [SOLVED:] Copy a single field from Access to Excel (1 replies)
  131. API Help Needed (3 replies)
  132. [SOLVED:] Copy certain worksheets from one workbook to another while keeping format (2 replies)
  133. [SOLVED:] vba help on declaring varible (3 replies)
  134. Ifnumber & Search with mulitple Conditions (1 replies)
  135. VBA too long-winded help needed. (9 replies)
  136. [SOLVED:] Worksheet collections in formula? (2 replies)
  137. Best method to check range completion before running rest of program. (2 replies)
  138. VBA-Extract only number from a string (4 replies)
  139. Excel 2016 .CopyPicture (1 replies)
  140. Convert Userform with a scrollbar into pdf (0 replies)
  141. SUM for a dynamic table (3 replies)
  142. [SOLVED:] Transferring data to a summary spreadsheet (2 replies)
  143. Excel VBA IMAGE help! (12 replies)
  144. vba consolidation of specific sheets data and Pasting in specific Mater sheets (1 replies)
  145. Hyperlink function reference multiple cells? (1 replies)
  146. Transferring Userform data to excel (6 replies)
  147. [SLEEPER:] VBA Userform Precedence (20 replies)
  148. [SOLVED:] Break text (3 replies)
  149. Copying certain rows of worksheet into new worksheet depending on date (1 replies)
  150. When changing Row B in Sheet 2 automatically do sorting with Row B in Sheet 1 (5 replies)
  151. [SOLVED:] Copying only values in VBA (3 replies)
  152. Repeat code for each row (4 replies)
  153. CopyRow help for multiple tabs (1 replies)
  154. First VBA project summary file please help (3 replies)
  155. [SOLVED:] VBA outlook (3 replies)
  156. Pivot Table not updating after Cut and Pasting Values to Data WS (1 replies)
  157. [SOLVED:] Open Folder with Comma and Ampersand in Name (9 replies)
  158. IF function in VBA - Can't COPY (6 replies)
  159. Help w/Offset Paste (2 replies)
  160. Populate Form Label Captions from Worksheet (2 replies)
  161. Ink Signature to cell (3 replies)
  162. VBA Macros Copy Paste Seed Up Help (3 replies)
  163. Time stamp in a fixed cell when content of specific cells in row are changed (8 replies)
  164. Class Does not suppor automation or does not support expected interface (1 replies)
  165. Deleting Data from Database using VBA (1 replies)
  166. Manipulate 2 different columns to become one (4 replies)
  167. VBA Column comparison against sheet and viceversa (2 replies)
  168. [SOLVED:] dblclick cell text cursor blinking (3 replies)
  169. Delete by Dates (1 replies)
  170. Excel Date formatting issue (1 replies)
  171. Change from Internet Explore to Google Chrome (1 replies)
  172. Switch case not giving desired product (7 replies)
  173. function keys open wrong dialog (1 replies)
  174. [SLEEPER:] Help Logging into Website with VBA (0 replies)
  175. [SOLVED:] EXCEL (macro) - Analysis of hourly intervals from sectional graph, correlation (20 replies)
  176. Move data from sheet 1 to 2 (2 replies)
  177. [SOLVED:] Concatenate cells with leading zeros vba (9 replies)
  178. [SLEEPER:] Convert PDF data into Excel or txt using VBA (3 replies)
  179. [SOLVED:] Script to loop match initial search term in data column to find the value of cell bel (2 replies)
  180. Deleting specific cells when a condition is no longer met (0 replies)
  181. Linest() <> Chart Trendline Formula (4 replies)
  182. Sorting Issues (0 replies)
  183. [SOLVED:] Run code on each cell until month changes (6 replies)
  184. [SOLVED:] VBA to extract data from WebPages (4 replies)
  185. [SLEEPER:] VBA & IE Form (1 replies)
  186. Excel VBA performance variance issue (5 replies)
  187. collection / array help (6 replies)
  188. VBA - Help me to solve this one, makro who can select between 3 sheets (13 replies)
  189. [SOLVED:] Automatically filter selected worksheets by date criteria (4 replies)
  190. Automatically copy certain cells from rows from one Worksheet into another Worksheet (0 replies)
  191. VBA Power Analysis Macro help (8 replies)
  192. [SOLVED:] Extracting Dates (14 replies)
  193. Import CSV File to Workbook (2 replies)
  194. Excel VBA macro to fill web form using excel data (0 replies)
  195. [SLEEPER:] Excel macro to fill web form using excel data (3 replies)
  196. [SOLVED:] Help with Offset and r Resize formulas to select a range. (5 replies)
  197. checkbox in excel (0 replies)
  198. Change color of cell/cells (2 replies)
  199. Replace functions with hard values (1 replies)
  200. Username to populate (0 replies)
  201. [SOLVED:] Very simple problem with no solution found (7 replies)
  202. Invoice date help (2 replies)
  203. [SOLVED:] Merging two Private Sub (6 replies)
  204. Using Macro to Pull in New Data Every Month (0 replies)
  205. [SOLVED:] Multiple Consecutive Line Feeds Using vbCrLf (2 replies)
  206. Find a last row and insert a values (7 replies)
  207. [SOLVED:] Copy and paste row of data to another worksheet macro (6 replies)
  208. [SOLVED:] Count_Colours_Not_Duplicate (6 replies)
  209. Comparing Data Across Sheets, with Multiple Variables (3 replies)
  210. Loop Thru Cells (1 replies)
  211. [SOLVED:] how to create a excel macro (button) that will show next number from a list? (6 replies)
  212. Print from Image Object in Sheet using VBA (range of print changed when filter table) (0 replies)
  213. [SOLVED:] VBA Unprotect not working properly (2 replies)
  214. [SOLVED:] Remove lines with no entries and copy back some data (5 replies)
  215. xlDown not returning last used cell (18 replies)
  216. copy email body to excel (0 replies)
  217. Userform - Different rights for differenz users (6 replies)
  218. [SOLVED:] Enable and disable calculations for a range of cells (1 replies)
  219. Toggle SUM/AVG on Pivot Table (7 replies)
  220. VBA code for Autofit row height for rows with merged and unmerged/normal cells (1 replies)
  221. [SOLVED:] Find a cell in a range based on a condition & change the value of the cell beneath (8 replies)
  222. UserForm Retrieve Data From Correct Sheet, based on Combo Box Value (1 replies)
  223. How do i extract a part of text file content (4 replies)
  224. Need help with my macro "Sub or function not defined" (1 replies)
  225. Getting VBA to decide which cell to use (1 replies)
  226. VBA, i want the value, not the formula (4 replies)
  227. [SOLVED:] Using a variable to call either a form or a sheet (4 replies)
  228. [SOLVED:] Help with an array formula (3 replies)
  229. [SOLVED:] Compare dates - password required if expired (5 replies)
  230. Internal Hyperlinks in Pivot Tables (7 replies)
  231. How can remove " after do replace in beginning and end of cell (8 replies)
  232. [SOLVED:] Converting a string by detecting Chr(183) (2 replies)
  233. Embedded objects in Excel (0 replies)
  234. [SOLVED:] Issues with Arrays and DLLs (10 replies)
  235. [SOLVED:] Cell with multiple lines of data , delete lines without # into one line (8 replies)
  236. Issue with sending the active workbook & printscreen via Lotus Notes (6 replies)
  237. callback for Application.Run (2 replies)
  238. Stuck on VLOOKUP VBA using variables (11 replies)
  239. [SOLVED:] VBA Copy and Paste data form one workbook to another.. Problem is data change every w (8 replies)
  240. Problems with simple counter (2 replies)
  241. [SOLVED:] NEED HELP RESCTRUCTURING MACRO TO FIT MY WORK SHEET, PLEASE. (3 replies)
  242. Speedup VBA (4 replies)
  243. excel formula and vba automation help (6 replies)
  244. Available Procedures in COM add-in (1 replies)
  245. INSERT OVERWRITE INTO correct syntax? (2 replies)
  246. [SOLVED:] Editing the contents of a Match Index Cell through VBA (2 replies)
  247. Email and HTML (5 replies)
  248. TOC macro to skip displaying hidden sheets (4 replies)
  249. Newton's Method Iteration Code in VBA- No errors but will not output (3 replies)
  250. Automatic numbering up, with two matches (26 replies)