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: Find & Replace Letter At End Of Number Only (6 replies)
  2. [SOLVED:] inputbox cancel (3 replies)
  3. Solved: Select File from Form (6 replies)
  4. Is this possible with VBA? (4 replies)
  5. Solved: Occasional filter\sort on worksheet_change glitch (2 replies)
  6. Have txtBox search results populated in listbox (6 replies)
  7. Compare 2 Columns of Excel Sheet (17 replies)
  8. Solved: Print Selected Cells to Another Cell (4 replies)
  9. pulling data from different reports into master workbook (1 replies)
  10. Sheet/Tab Copy Limit? (5 replies)
  11. Find all occurance of cell value from another work book (1 replies)
  12. URGENT: APPEND DATA (1 replies)
  13. Solved: Code stops? (2 replies)
  14. Solved: Writ data to Excel problem (3 replies)
  15. Error Box help (3 replies)
  16. how to store arbitrary selection area to two-dim array (3 replies)
  17. Solved: Reduce Numbers Down To A Specific Value (10 replies)
  18. Looking for functions: IsUserPressingAMouseButton / IsUserPressingAKey (1 replies)
  19. Solved: string split for date (8 replies)
  20. Cells with values (4 replies)
  21. Formatting dates (5 replies)
  22. Solved: Fill Blank Cells with Value to the Left (8 replies)
  23. Concatenate Multiple Rows (10 replies)
  24. Solved: Help to include network drive when browsing for file location (2 replies)
  25. Looking up Records (3 replies)
  26. [SOLVED:] Can I create an Array from 1 to AutoFilter.Range.Columns.Count (2 replies)
  27. Pass TextBox Value to Access Query (19 replies)
  28. [SOLVED:] Looping around a userform textbox (9 replies)
  29. concatenate a range of cells with header values (15 replies)
  30. Checking Columns for Numbers (8 replies)
  31. Solved: find string in column A and past used range of row to sheet 2 (11 replies)
  32. Unload UserForm resets project (5 replies)
  33. Solved: Paste data with adding spaces between letters (1 replies)
  34. "countif" in multiple worksheets using VBA (5 replies)
  35. Forgot on Solved: Insert A Row (4 replies)
  36. VBA Coding window highlights text red and then deletes (6 replies)
  37. [SLEEPER:] Error message (2 replies)
  38. find last used row but not include formula that returns blank (3 replies)
  39. Excel VBA Shopping Cart (2 replies)
  40. My VBA code takes 4 hours to run (5 replies)
  41. match data and return datalength (3 replies)
  42. Euro Sign wont work (3 replies)
  43. application.undo (2 replies)
  44. Cut cells and move (5 replies)
  45. Can anyone crack this file? (4 replies)
  46. Little help with Visual Basics (2 replies)
  47. Solved: keybd_event API missing information on User Form (8 replies)
  48. Sleeper: Auto Update VBA Project (9 replies)
  49. Quick Case Statement (2 replies)
  50. Solved: Apply Row 16 cell formats to all rows (33 replies)
  51. Load | Delimited file into Sheet3 of the excel workbook (2 replies)
  52. Validate Email in a Excel Cell (5 replies)
  53. multiple target address (2 replies)
  54. Solved: UserForm - Need Help! (21 replies)
  55. Solved: Comment filling (0 replies)
  56. NUMBER ARRANGER (7 replies)
  57. Excel UK Developers Conference 2012 (8 replies)
  58. Excel data table filtering - need help (4 replies)
  59. Run sub when sheet is activated (2 replies)
  60. Solved: Comparing two sheets. - I've seen code here before that I like, but I can't find (1 replies)
  61. Nesting Complex IF Statements (2 replies)
  62. Store selected ranges address in sheet (1 replies)
  63. Creating Charts using VBA (2 replies)
  64. unzipped worksheet - protection (0 replies)
  65. Creating a folder in the drive (1 replies)
  66. Populating Combobox list from listbox entries (1 replies)
  67. To consolidate master data from different worksheets (1 replies)
  68. Solved: Copy Tab from close workbook into an open workbook (2 replies)
  69. Remove hundreds of empty rows (2 replies)
  70. VBA Macro to split cells at every ";" (3 replies)
  71. Displaying Total CMD Button (2 replies)
  72. Solved: Import text from Excel to a PDF file (4 replies)
  73. Text file read/write. (1 replies)
  74. Check shared file open. (1 replies)
  75. URGENT HELP REQUIRED (8 replies)
  76. save a single sheet filedialogbox (2 replies)
  77. Searching a keyword in a pdf file from excel using vba (0 replies)
  78. Solved: How can I prevent Button Double clicks? (3 replies)
  79. Validaing Userform Input (9 replies)
  80. How to get variables numbers from array of numbers (9 replies)
  81. Solved: Need a msgbox to report to me the missing record number (18 replies)
  82. Counting entries between dates using sumproduct? (5 replies)
  83. Help inserting a new row into several worksheets and copy formula (3 replies)
  84. Date array function has type mismatch error (1 replies)
  85. Problems with Worksheet_SelectionChange (2 replies)
  86. Solved: Insert A Row (6 replies)
  87. Find in different workbook (4 replies)
  88. Check for open file. (5 replies)
  89. Remove double quotes in text (csv) file (23 replies)
  90. help: export to csv (0 replies)
  91. Solved: Could you please help me to use VBA for random name (8 replies)
  92. Solved: Need to log macro errors (4 replies)
  93. Migrate from Excel file to another Excel file provided (1 replies)
  94. Searching through a list (1 replies)
  95. consolidate two worksheets. different table structure (7 replies)
  96. Copy Non Error values (10 replies)
  97. [SOLVED:] Modify macro to get group of data (6 replies)
  98. How to Disable Set Print Area in Excel? (3 replies)
  99. UDFunction triggering on cell refresh vs change in cell value (4 replies)
  100. Macro Code for referring to a value in a drop down list (4 replies)
  101. match data in certain ranges (4 replies)
  102. Excel Compatibility 2007 back to 2002 (1 replies)
  103. Remove all Duplicate rows in Excel based on multiple colum (15 replies)
  104. Solved: Error when running file in IE7 (0 replies)
  105. Comparison of 2 versions of Excel sheet (0 replies)
  106. Skip to next empty cell (2 replies)
  107. Search for a folder and return full path. (8 replies)
  108. Solved: Text File Comparison Question (7 replies)
  109. Macro to Replace Query (1 replies)
  110. Complex IF Formula Errors as VBA Code (8 replies)
  111. once data input for 2 sheets in different table structure (3 replies)
  112. How to open wk3 (1-2-3) with Microsoft Excel 2007 (1 replies)
  113. [SOLVED:] Userform TextBoxes / Inserting Dates (6 replies)
  114. Conundrum: looping sheets, matching columns and copying from one workbook to another (0 replies)
  115. Sumif macro in Excel for SAPBW Bex reports (1 replies)
  116. VB code for delete the columns (8 replies)
  117. VBA code for backing up excel files (1 replies)
  118. Solved: Copy found cell, not column (2 replies)
  119. Looping and Transposing in excel (0 replies)
  120. Show a Form During General Recalculations (3 replies)
  121. VLookup inside a UserForm (11 replies)
  122. VBA code to hide ribbon / menu bar ? (9 replies)
  123. Macro to run advanced filter (6 replies)
  124. Excel VBA code to change the User Interface to default view upon opening (1 replies)
  125. Run-time error 1004 - on a sort? (3 replies)
  126. Solved: Why is this code not locking the cells in the selected row ? (4 replies)
  127. Help with Run Time Error 1004 Document Not Saved (0 replies)
  128. VLOOKUP File Path (2 replies)
  129. populate a memo fields (0 replies)
  130. [SLEEPER:] Alternative to Union Function/Combining Ranges (18 replies)
  131. Automatic Filename from cell info (3 replies)
  132. SQL WHERE STATEMENT (16 replies)
  133. macro to import data from text file to excel worksheet (5 replies)
  134. How to copy cells/rows with formula? (5 replies)
  135. pivot table subtotals (0 replies)
  136. Map Number Ranges to other Sheets? (1 replies)
  137. Delete Row until Data Matches (8 replies)
  138. Solved: Trouble with VBA Code (5 replies)
  139. Can Forms Be Truly Docked? (2 replies)
  140. [SOLVED:] Round down (2 replies)
  141. Compile Error: Automation Error (6 replies)
  142. Solved: Selecting only certain rows to use in Combobox list (3 replies)
  143. Solved: Split a Directory into Smaller Directories and Copy the Files Across (7 replies)
  144. Solved: Disappearing Command Buttons (ActiveX and Forms type) when copying sheet... (3 replies)
  145. Solved: Loop problem (1 replies)
  146. Solved: Need faster code to lock and unlock the activesheet used range. (4 replies)
  147. Else If Loop (4 replies)
  148. Solved: Highlighting a specific Text in excel sheet by macro (11 replies)
  149. Solved: Mailer code depending on variables in columns (2 replies)
  150. Securing a PDF using Excel VBA (2 replies)
  151. [SLEEPER:] short scrip to do a check (0 replies)
  152. Can a Userform generate a record #? (0 replies)
  153. [SOLVED:] VBA Autofilter call does not work (2 replies)
  154. VBA in Excel to Word: Searching and Replacing (3 replies)
  155. Find Duplicates using VBA (3 replies)
  156. Adding a drop down menu (0 replies)
  157. VBA Pivot Table Help (3 replies)
  158. How to identify method for an assigned shortcut? (6 replies)
  159. Link for help (to not duplicate post) (0 replies)
  160. Skill Matrix (0 replies)
  161. How to add references & add-ins via VBA (6 replies)
  162. API call working in Excel 2007 but not 2010! (1 replies)
  163. Count maximum specific combinations between 12 columns (16 replies)
  164. Cells Background Colour Match Help :bow: (2 replies)
  165. Looping Vs Non Looping approach (7 replies)
  166. MsgBox used during On Error Resume Next ? (5 replies)
  167. MACRO for RADIO BUTTON (1 replies)
  168. Solved: Need to use the sheets change event to undo changes made to Cell A1 (3 replies)
  169. Run Excel Macros IF... (5 replies)
  170. Error '9': Subscript out of range when trying to change codename of a sheet (3 replies)
  171. Does Protecting a Project protect against the user selecting the design mode button? (2 replies)
  172. FUNCTION OR CODE TO DIVIDE NUMBERS. (7 replies)
  173. Confused with classes a bit (5 replies)
  174. Solved: Loop not running correctly (7 replies)
  175. Importing a .txt file based on file title that is input by user (3 replies)
  176. Activiate function when another cell is triggered from a function such as doubleclick (1 replies)
  177. Sub causing error 9 (12 replies)
  178. Copy row and one above it loop error? (3 replies)
  179. Solved: Control listbox results whit a combobox. (3 replies)
  180. compare and get data from many sheets and place it in another sheet (1 replies)
  181. How To Set ActiveWorkbook Worksheet in Recordset (5 replies)
  182. [SOLVED:] Cut and Paste to different cell (2 replies)
  183. Solved: Help needed (4 replies)
  184. Create Daily Report From Master Tracker (2 replies)
  185. Combining data from multiple workbooks (specific sheet) into a specific workbook (1 replies)
  186. Simple Obfucator? (0 replies)
  187. Problems Logging in to a website using Excel (3 replies)
  188. Untrapped Error 9 in code (4 replies)
  189. Solved: Run Macro on Specific Sheet (9 replies)
  190. Solved: adding a prefix letter (1 replies)
  191. Solved: Excel Macro Formula (3 replies)
  192. Need to generate Open Order Report Filtered By Customer and Due date (21 replies)
  193. concatenate multiple rows (3 replies)
  194. Help calculating Max of aggregate sum (1 replies)
  195. Creating a report (8 replies)
  196. date criteria (3 replies)
  197. Extract Data from .txt file (2 replies)
  198. Extract string from text file (2 replies)
  199. Is this a good way to export what is in a cell? (1 replies)
  200. How to insert value "Small Enterprise (alt)" using VBA Macro (0 replies)
  201. Solved: Comparing columns A and B. Would like to eliminate #NA results. (19 replies)
  202. The sheet selection depends on the variable? (1 replies)
  203. How to set Multiple instr (4 replies)
  204. Solved: Modify Loop Until IsEmpty (4 replies)
  205. Unzipping multiple files using VBA - Why is this happening? (6 replies)
  206. Create an alert popup (1 replies)
  207. Solved: obtain data from 3 input with conditions (7 replies)
  208. Spinbutton and combobox with a listbox help ! (2 replies)
  209. Solved: Need reminder for previous day (6 replies)
  210. VLOOKUP Returning "FALSE" Instead Of Zero (3 replies)
  211. search instr in multiple (1 replies)
  212. Solved: Convert Fractions To Decimals in UserForm (3 replies)
  213. Import xml to Excel without parsing text or format string in text (1 replies)
  214. Solved: AuotoFill is slower than using the Range. - Are there other factors to consider? (4 replies)
  215. highlight a cell based on 2 cells matching (2 replies)
  216. [SLEEPER:] BLINKING CELL IN EXCEL (3 replies)
  217. Solved: Adding Time Stipulation to VBA (2 replies)
  218. Can you interrupt a data load? (3 replies)
  219. Processing records in VBA (1 replies)
  220. Solved: Need Auto Save once value is entered in cell. (9 replies)
  221. Generate Dynamic Diagram (1 replies)
  222. Solved: Selecting cells (1 replies)
  223. Solved: Export a sheet as file (13 replies)
  224. Solved: Understanding VBA Code (1 replies)
  225. [SOLVED:] Creating Sequence Numbers (6 replies)
  226. Solved: Looping through wooksheets (2 replies)
  227. Sum of Array Using Sub procedure and Function (4 replies)
  228. Solved: Excel Chart: How to Label a Chart Series using VBA (6 replies)
  229. [SOLVED:] Create a Desktop Shortcut for New Folder (2 replies)
  230. Open 2 worksheet at the same time (1 replies)
  231. reduce the macro (3 replies)
  232. Solved: help needed with vba to delete certain charts (2 replies)
  233. Solved: Replace without looping?? (14 replies)
  234. Transfer the data to another sheet (3 replies)
  235. Delete / Clear all Rows begining at Cell "X" (3 replies)
  236. Solved: Formatting across worksheets (1 replies)
  237. UDF Lookup Issue (1 replies)
  238. results when step through, none when run (5 replies)
  239. Highlight the header being used to AutoFilter a range (4 replies)
  240. Chart based on Multiple criteria (0 replies)
  241. Reading Text File into Excel (1 replies)
  242. Solved: VBA to find path for multiple files (6 replies)
  243. Accessing Range Name Causes Run-Time Error (6 replies)
  244. Copy from one sheet to another (0 replies)
  245. Solved: Repeat B2 values based on rows on column A (2 replies)
  246. Solved: Associate values checkbox and sum (3 replies)
  247. Ayuda con registros en Listbox (1 replies)
  248. Solved: CheckBox Question (4 replies)
  249. [SLEEPER:] Excel 2003: How to disable cell drag and drop when workbook is opened? (48 replies)
  250. access macro from another workbook (2 replies)