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. Remove hundreds of empty rows (2 replies)
  2. VBA Macro to split cells at every ";" (3 replies)
  3. Displaying Total CMD Button (2 replies)
  4. Solved: Import text from Excel to a PDF file (4 replies)
  5. Text file read/write. (1 replies)
  6. Check shared file open. (1 replies)
  7. URGENT HELP REQUIRED (8 replies)
  8. save a single sheet filedialogbox (2 replies)
  9. Searching a keyword in a pdf file from excel using vba (0 replies)
  10. Solved: How can I prevent Button Double clicks? (3 replies)
  11. Validaing Userform Input (9 replies)
  12. How to get variables numbers from array of numbers (9 replies)
  13. Solved: Need a msgbox to report to me the missing record number (18 replies)
  14. Counting entries between dates using sumproduct? (5 replies)
  15. Help inserting a new row into several worksheets and copy formula (3 replies)
  16. Date array function has type mismatch error (1 replies)
  17. Problems with Worksheet_SelectionChange (2 replies)
  18. Solved: Insert A Row (6 replies)
  19. Find in different workbook (4 replies)
  20. Check for open file. (5 replies)
  21. Remove double quotes in text (csv) file (23 replies)
  22. help: export to csv (0 replies)
  23. Solved: Could you please help me to use VBA for random name (8 replies)
  24. Solved: Need to log macro errors (4 replies)
  25. Migrate from Excel file to another Excel file provided (1 replies)
  26. Searching through a list (1 replies)
  27. consolidate two worksheets. different table structure (7 replies)
  28. Copy Non Error values (10 replies)
  29. [SOLVED:] Modify macro to get group of data (6 replies)
  30. How to Disable Set Print Area in Excel? (3 replies)
  31. UDFunction triggering on cell refresh vs change in cell value (4 replies)
  32. Macro Code for referring to a value in a drop down list (4 replies)
  33. match data in certain ranges (4 replies)
  34. Excel Compatibility 2007 back to 2002 (1 replies)
  35. Remove all Duplicate rows in Excel based on multiple colum (15 replies)
  36. Solved: Error when running file in IE7 (0 replies)
  37. Comparison of 2 versions of Excel sheet (0 replies)
  38. Skip to next empty cell (2 replies)
  39. Search for a folder and return full path. (8 replies)
  40. Solved: Text File Comparison Question (7 replies)
  41. Macro to Replace Query (1 replies)
  42. Complex IF Formula Errors as VBA Code (8 replies)
  43. once data input for 2 sheets in different table structure (3 replies)
  44. How to open wk3 (1-2-3) with Microsoft Excel 2007 (1 replies)
  45. Solved: Userform TextBoxes / Inserting Dates (6 replies)
  46. Conundrum: looping sheets, matching columns and copying from one workbook to another (0 replies)
  47. Sumif macro in Excel for SAPBW Bex reports (1 replies)
  48. VB code for delete the columns (8 replies)
  49. VBA code for backing up excel files (1 replies)
  50. Solved: Copy found cell, not column (2 replies)
  51. Looping and Transposing in excel (0 replies)
  52. Show a Form During General Recalculations (3 replies)
  53. VLookup inside a UserForm (11 replies)
  54. VBA code to hide ribbon / menu bar ? (9 replies)
  55. Macro to run advanced filter (6 replies)
  56. Excel VBA code to change the User Interface to default view upon opening (1 replies)
  57. Run-time error 1004 - on a sort? (3 replies)
  58. Solved: Why is this code not locking the cells in the selected row ? (4 replies)
  59. Help with Run Time Error 1004 Document Not Saved (0 replies)
  60. VLOOKUP File Path (2 replies)
  61. populate a memo fields (0 replies)
  62. Alternative to Union Function/Combining Ranges (18 replies)
  63. Automatic Filename from cell info (3 replies)
  64. SQL WHERE STATEMENT (16 replies)
  65. macro to import data from text file to excel worksheet (5 replies)
  66. How to copy cells/rows with formula? (5 replies)
  67. pivot table subtotals (0 replies)
  68. Map Number Ranges to other Sheets? (1 replies)
  69. Delete Row until Data Matches (8 replies)
  70. Solved: Trouble with VBA Code (5 replies)
  71. Can Forms Be Truly Docked? (2 replies)
  72. Solved: round down (2 replies)
  73. Compile Error: Automation Error (6 replies)
  74. Solved: Selecting only certain rows to use in Combobox list (3 replies)
  75. Solved: Split a Directory into Smaller Directories and Copy the Files Across (7 replies)
  76. Solved: Disappearing Command Buttons (ActiveX and Forms type) when copying sheet... (3 replies)
  77. Solved: Loop problem (1 replies)
  78. Solved: Need faster code to lock and unlock the activesheet used range. (4 replies)
  79. Else If Loop (4 replies)
  80. Solved: Highlighting a specific Text in excel sheet by macro (11 replies)
  81. Solved: Mailer code depending on variables in columns (2 replies)
  82. Securing a PDF using Excel VBA (2 replies)
  83. short scrip to do a check (0 replies)
  84. Can a Userform generate a record #? (0 replies)
  85. [SOLVED:] VBA Autofilter call does not work (2 replies)
  86. VBA in Excel to Word: Searching and Replacing (3 replies)
  87. Find Duplicates using VBA (3 replies)
  88. Adding a drop down menu (0 replies)
  89. VBA Pivot Table Help (3 replies)
  90. How to identify method for an assigned shortcut? (6 replies)
  91. Link for help (to not duplicate post) (0 replies)
  92. Skill Matrix (0 replies)
  93. How to add references & add-ins via VBA (6 replies)
  94. API call working in Excel 2007 but not 2010! (1 replies)
  95. Count maximum specific combinations between 12 columns (16 replies)
  96. Cells Background Colour Match Help :bow: (2 replies)
  97. Looping Vs Non Looping approach (7 replies)
  98. MsgBox used during On Error Resume Next ? (5 replies)
  99. MACRO for RADIO BUTTON (1 replies)
  100. Solved: Need to use the sheets change event to undo changes made to Cell A1 (3 replies)
  101. Run Excel Macros IF... (5 replies)
  102. Error '9': Subscript out of range when trying to change codename of a sheet (3 replies)
  103. Does Protecting a Project protect against the user selecting the design mode button? (2 replies)
  104. FUNCTION OR CODE TO DIVIDE NUMBERS. (7 replies)
  105. Confused with classes a bit (5 replies)
  106. Solved: Loop not running correctly (7 replies)
  107. Importing a .txt file based on file title that is input by user (3 replies)
  108. Activiate function when another cell is triggered from a function such as doubleclick (1 replies)
  109. Sub causing error 9 (12 replies)
  110. Copy row and one above it loop error? (3 replies)
  111. Solved: Control listbox results whit a combobox. (3 replies)
  112. compare and get data from many sheets and place it in another sheet (1 replies)
  113. How To Set ActiveWorkbook Worksheet in Recordset (5 replies)
  114. [SOLVED:] Cut and Paste to different cell (2 replies)
  115. Solved: Help needed (4 replies)
  116. Create Daily Report From Master Tracker (2 replies)
  117. Combining data from multiple workbooks (specific sheet) into a specific workbook (1 replies)
  118. Simple Obfucator? (0 replies)
  119. Problems Logging in to a website using Excel (3 replies)
  120. Untrapped Error 9 in code (4 replies)
  121. Solved: Run Macro on Specific Sheet (9 replies)
  122. Solved: adding a prefix letter (1 replies)
  123. Solved: Excel Macro Formula (3 replies)
  124. Need to generate Open Order Report Filtered By Customer and Due date (21 replies)
  125. concatenate multiple rows (3 replies)
  126. Help calculating Max of aggregate sum (1 replies)
  127. Creating a report (8 replies)
  128. date criteria (3 replies)
  129. Extract Data from .txt file (2 replies)
  130. Extract string from text file (2 replies)
  131. Is this a good way to export what is in a cell? (1 replies)
  132. How to insert value "Small Enterprise (alt)" using VBA Macro (0 replies)
  133. Solved: Comparing columns A and B. Would like to eliminate #NA results. (19 replies)
  134. The sheet selection depends on the variable? (1 replies)
  135. How to set Multiple instr (4 replies)
  136. Solved: Modify Loop Until IsEmpty (4 replies)
  137. Unzipping multiple files using VBA - Why is this happening? (6 replies)
  138. Create an alert popup (1 replies)
  139. Solved: obtain data from 3 input with conditions (7 replies)
  140. Spinbutton and combobox with a listbox help ! (2 replies)
  141. Solved: Need reminder for previous day (6 replies)
  142. VLOOKUP Returning "FALSE" Instead Of Zero (3 replies)
  143. search instr in multiple (1 replies)
  144. Solved: Convert Fractions To Decimals in UserForm (3 replies)
  145. Import xml to Excel without parsing text or format string in text (1 replies)
  146. Solved: AuotoFill is slower than using the Range. - Are there other factors to consider? (4 replies)
  147. highlight a cell based on 2 cells matching (2 replies)
  148. [SLEEPER:] BLINKING CELL IN EXCEL (3 replies)
  149. Solved: Adding Time Stipulation to VBA (2 replies)
  150. Can you interrupt a data load? (3 replies)
  151. Processing records in VBA (1 replies)
  152. Solved: Need Auto Save once value is entered in cell. (9 replies)
  153. Generate Dynamic Diagram (1 replies)
  154. Solved: Selecting cells (1 replies)
  155. Solved: Export a sheet as file (13 replies)
  156. Solved: Understanding VBA Code (1 replies)
  157. [SOLVED:] Creating Sequence Numbers (6 replies)
  158. Solved: Looping through wooksheets (2 replies)
  159. Sum of Array Using Sub procedure and Function (4 replies)
  160. Solved: Excel Chart: How to Label a Chart Series using VBA (6 replies)
  161. [SOLVED:] Create a Desktop Shortcut for New Folder (2 replies)
  162. Open 2 worksheet at the same time (1 replies)
  163. reduce the macro (3 replies)
  164. Solved: help needed with vba to delete certain charts (2 replies)
  165. Solved: Replace without looping?? (14 replies)
  166. Transfer the data to another sheet (3 replies)
  167. Delete / Clear all Rows begining at Cell "X" (3 replies)
  168. Solved: Formatting across worksheets (1 replies)
  169. UDF Lookup Issue (1 replies)
  170. results when step through, none when run (5 replies)
  171. Highlight the header being used to AutoFilter a range (4 replies)
  172. Chart based on Multiple criteria (0 replies)
  173. Reading Text File into Excel (1 replies)
  174. Solved: VBA to find path for multiple files (6 replies)
  175. Accessing Range Name Causes Run-Time Error (6 replies)
  176. Copy from one sheet to another (0 replies)
  177. Solved: Repeat B2 values based on rows on column A (2 replies)
  178. Solved: Associate values checkbox and sum (3 replies)
  179. Ayuda con registros en Listbox (1 replies)
  180. Solved: CheckBox Question (4 replies)
  181. Excel 2003: How to disable cell drag and drop when workbook is opened? (48 replies)
  182. access macro from another workbook (2 replies)
  183. Date issue (1 replies)
  184. Indexing characters in a string (7 replies)
  185. Help with VBA Code (9 replies)
  186. Assign Formula Result to variable (14 replies)
  187. Solved: EXCEL VBA - drill down feature (3 replies)
  188. Autofill (11 replies)
  189. Problem decimal calculation in VBA (2 replies)
  190. Exporting data from content control fields in word to excel 2010 (18 replies)
  191. [SOLVED:] How to close the particular excel without saving? (1 replies)
  192. Excel with different sheetname (1 replies)
  193. How to get the file name in the folder? (1 replies)
  194. Solved: Maximum field length (1 replies)
  195. Solved: LOOK CELL IN COLUMN THEN HIGHLIGHT (3 replies)
  196. Solved: Page Breaks in body text (1 replies)
  197. Loop through the date (1 replies)
  198. Solved: Moving cell data (2 replies)
  199. Managing Two Cells With Similar Ranges (1 replies)
  200. Need help with some VB Programming (2 replies)
  201. Solved: call a macro from within another macro works then doesn't (3 replies)
  202. Solved: Paste Formats from Above (7 replies)
  203. Solved: Help with Code (8 replies)
  204. Solved: Detecting / Avoiding Duplicates in a VBA userform. (30 replies)
  205. Solved: Pulling data from seperate worksheets into cumulative one. (7 replies)
  206. Populating a range with formulas (3 replies)
  207. Solved: Import a single column text file (8 replies)
  208. Highlighting Row (2 replies)
  209. How to use Userform to input a list of data (5 replies)
  210. Using IF/ Do Condition with VBA (1 replies)
  211. Need some help on the Function (1 replies)
  212. Getting data from the web (1 replies)
  213. Populating worksheet row with listbox values (1 replies)
  214. Value of Multi column combobox (3 replies)
  215. Add Background to PDF using Excel VBA (17 replies)
  216. Function Module (Display and Send) (2 replies)
  217. Call Two different Macros using IF (2 replies)
  218. Macro to format borders within tables in Excel file (1 replies)
  219. Agenda using VB or formula? (0 replies)
  220. Wake up Lan (1 replies)
  221. Solved: Recent session date (3 replies)
  222. Solved: How to run a macro when user clicks a value in a dropdown box (form control, not UFM) (6 replies)
  223. Internet Explorer Automation: How to handle connection timeout? (3 replies)
  224. Autofiltering macro - filters text but not the numbers (3 replies)
  225. Help in VBA Coding (do while / loop until) (1 replies)
  226. Solved: Macro to Combine Multiple Workbooks into one Workbook (16 replies)
  227. Export to csv based upon date/time criteria (4 replies)
  228. Select Range to copy Values to (1 replies)
  229. Solved: Timer Panel\Please Wait userform Help (5 replies)
  230. Why is Excel asking me to save......twice? (8 replies)
  231. Solved: view all exceptions (3 replies)
  232. Sum the total value for that column (4 replies)
  233. Solved: Check Box Formula (10 replies)
  234. [SOLVED:] Workbooks.Add (force XLSX format) (1 replies)
  235. VBA for looping cell change (3 replies)
  236. Solved: Grouping Modules? (7 replies)
  237. Code or conditional formatting (9 replies)
  238. Use Excel To Open Word (22 replies)
  239. List of files in directory by date created (11 replies)
  240. Copying Multiple worksheets in Multiple workbooks to one single workbook (4 replies)
  241. Array formula which ignores blanks and duplicates (0 replies)
  242. xla working on xp 2003 / xp 2007 - not working on win7 / 2007 (2 replies)
  243. Autofilter 1 column based on multiple criteria (2 replies)
  244. Find string starting with... (1 replies)
  245. Excel 2010 funcres reference issue (2 replies)
  246. some rows wanted (52 replies)
  247. Looping through cells (contents of cell seperated by commas) and performing vlookups (8 replies)
  248. Insert Rows (1 replies)
  249. Counting the Rows including blank ones (4 replies)
  250. filter upon color (2 replies)