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. Securing a PDF using Excel VBA (2 replies)
  2. short scrip to do a check (0 replies)
  3. Can a Userform generate a record #? (0 replies)
  4. [SOLVED:] VBA Autofilter call does not work (2 replies)
  5. VBA in Excel to Word: Searching and Replacing (3 replies)
  6. Find Duplicates using VBA (3 replies)
  7. Adding a drop down menu (0 replies)
  8. VBA Pivot Table Help (3 replies)
  9. How to identify method for an assigned shortcut? (6 replies)
  10. Link for help (to not duplicate post) (0 replies)
  11. Skill Matrix (0 replies)
  12. How to add references & add-ins via VBA (6 replies)
  13. API call working in Excel 2007 but not 2010! (1 replies)
  14. Count maximum specific combinations between 12 columns (16 replies)
  15. Cells Background Colour Match Help :bow: (2 replies)
  16. Looping Vs Non Looping approach (7 replies)
  17. MsgBox used during On Error Resume Next ? (5 replies)
  18. MACRO for RADIO BUTTON (1 replies)
  19. Solved: Need to use the sheets change event to undo changes made to Cell A1 (3 replies)
  20. Run Excel Macros IF... (5 replies)
  21. Error '9': Subscript out of range when trying to change codename of a sheet (3 replies)
  22. Does Protecting a Project protect against the user selecting the design mode button? (2 replies)
  23. FUNCTION OR CODE TO DIVIDE NUMBERS. (7 replies)
  24. Confused with classes a bit (5 replies)
  25. Solved: Loop not running correctly (7 replies)
  26. Importing a .txt file based on file title that is input by user (3 replies)
  27. Activiate function when another cell is triggered from a function such as doubleclick (1 replies)
  28. Sub causing error 9 (12 replies)
  29. Copy row and one above it loop error? (3 replies)
  30. Solved: Control listbox results whit a combobox. (3 replies)
  31. compare and get data from many sheets and place it in another sheet (1 replies)
  32. How To Set ActiveWorkbook Worksheet in Recordset (5 replies)
  33. Solved: Cut and Paste to different cell (2 replies)
  34. Solved: Help needed (4 replies)
  35. Create Daily Report From Master Tracker (2 replies)
  36. Combining data from multiple workbooks (specific sheet) into a specific workbook (1 replies)
  37. Simple Obfucator? (0 replies)
  38. Problems Logging in to a website using Excel (3 replies)
  39. Untrapped Error 9 in code (4 replies)
  40. Solved: Run Macro on Specific Sheet (9 replies)
  41. Solved: adding a prefix letter (1 replies)
  42. Solved: Excel Macro Formula (3 replies)
  43. Need to generate Open Order Report Filtered By Customer and Due date (21 replies)
  44. concatenate multiple rows (3 replies)
  45. Help calculating Max of aggregate sum (1 replies)
  46. Creating a report (8 replies)
  47. date criteria (3 replies)
  48. Extract Data from .txt file (2 replies)
  49. Extract string from text file (2 replies)
  50. Is this a good way to export what is in a cell? (1 replies)
  51. How to insert value "Small Enterprise (alt)" using VBA Macro (0 replies)
  52. Solved: Comparing columns A and B. Would like to eliminate #NA results. (19 replies)
  53. The sheet selection depends on the variable? (1 replies)
  54. How to set Multiple instr (4 replies)
  55. Solved: Modify Loop Until IsEmpty (4 replies)
  56. Unzipping multiple files using VBA - Why is this happening? (6 replies)
  57. Create an alert popup (1 replies)
  58. Solved: obtain data from 3 input with conditions (7 replies)
  59. Spinbutton and combobox with a listbox help ! (2 replies)
  60. Solved: Need reminder for previous day (6 replies)
  61. VLOOKUP Returning "FALSE" Instead Of Zero (3 replies)
  62. search instr in multiple (1 replies)
  63. Solved: Convert Fractions To Decimals in UserForm (3 replies)
  64. Import xml to Excel without parsing text or format string in text (1 replies)
  65. Solved: AuotoFill is slower than using the Range. - Are there other factors to consider? (4 replies)
  66. highlight a cell based on 2 cells matching (2 replies)
  67. BLINKING CELL IN EXCEL (3 replies)
  68. Solved: Adding Time Stipulation to VBA (2 replies)
  69. Can you interrupt a data load? (3 replies)
  70. Processing records in VBA (1 replies)
  71. Solved: Need Auto Save once value is entered in cell. (9 replies)
  72. Generate Dynamic Diagram (1 replies)
  73. Solved: Selecting cells (1 replies)
  74. Solved: Export a sheet as file (13 replies)
  75. Solved: Understanding VBA Code (1 replies)
  76. [SOLVED:] Creating Sequence Numbers (6 replies)
  77. Solved: Looping through wooksheets (2 replies)
  78. Sum of Array Using Sub procedure and Function (4 replies)
  79. Solved: Excel Chart: How to Label a Chart Series using VBA (6 replies)
  80. [SOLVED:] Create a Desktop Shortcut for New Folder (2 replies)
  81. Open 2 worksheet at the same time (1 replies)
  82. reduce the macro (3 replies)
  83. Solved: help needed with vba to delete certain charts (2 replies)
  84. Solved: Replace without looping?? (14 replies)
  85. Transfer the data to another sheet (3 replies)
  86. Delete / Clear all Rows begining at Cell "X" (3 replies)
  87. Solved: Formatting across worksheets (1 replies)
  88. UDF Lookup Issue (1 replies)
  89. results when step through, none when run (5 replies)
  90. Highlight the header being used to AutoFilter a range (4 replies)
  91. Chart based on Multiple criteria (0 replies)
  92. Reading Text File into Excel (1 replies)
  93. Solved: VBA to find path for multiple files (6 replies)
  94. Accessing Range Name Causes Run-Time Error (6 replies)
  95. Copy from one sheet to another (0 replies)
  96. Solved: Repeat B2 values based on rows on column A (2 replies)
  97. Solved: Associate values checkbox and sum (3 replies)
  98. Ayuda con registros en Listbox (1 replies)
  99. Solved: CheckBox Question (4 replies)
  100. Excel 2003: How to disable cell drag and drop when workbook is opened? (48 replies)
  101. access macro from another workbook (2 replies)
  102. Date issue (1 replies)
  103. Indexing characters in a string (7 replies)
  104. Help with VBA Code (9 replies)
  105. Assign Formula Result to variable (14 replies)
  106. Solved: EXCEL VBA - drill down feature (3 replies)
  107. Autofill (11 replies)
  108. Problem decimal calculation in VBA (2 replies)
  109. Exporting data from content control fields in word to excel 2010 (18 replies)
  110. [SOLVED:] How to close the particular excel without saving? (1 replies)
  111. Excel with different sheetname (1 replies)
  112. How to get the file name in the folder? (1 replies)
  113. Solved: Maximum field length (1 replies)
  114. Solved: LOOK CELL IN COLUMN THEN HIGHLIGHT (3 replies)
  115. Solved: Page Breaks in body text (1 replies)
  116. Loop through the date (1 replies)
  117. Solved: Moving cell data (2 replies)
  118. Managing Two Cells With Similar Ranges (1 replies)
  119. Need help with some VB Programming (2 replies)
  120. Solved: call a macro from within another macro works then doesn't (3 replies)
  121. Solved: Paste Formats from Above (7 replies)
  122. Detecting / Avoiding Duplicates in a VBA userform. (0 replies)
  123. Solved: Help with Code (8 replies)
  124. Solved: Detecting / Avoiding Duplicates in a VBA userform. (30 replies)
  125. Solved: Pulling data from seperate worksheets into cumulative one. (7 replies)
  126. Populating a range with formulas (3 replies)
  127. Solved: Import a single column text file (8 replies)
  128. Highlighting Row (2 replies)
  129. How to use Userform to input a list of data (5 replies)
  130. Using IF/ Do Condition with VBA (1 replies)
  131. Need some help on the Function (1 replies)
  132. Getting data from the web (1 replies)
  133. Populating worksheet row with listbox values (1 replies)
  134. Value of Multi column combobox (3 replies)
  135. Add Background to PDF using Excel VBA (17 replies)
  136. Function Module (Display and Send) (2 replies)
  137. Call Two different Macros using IF (2 replies)
  138. Macro to format borders within tables in Excel file (1 replies)
  139. Agenda using VB or formula? (0 replies)
  140. Wake up Lan (1 replies)
  141. Solved: Recent session date (3 replies)
  142. Solved: How to run a macro when user clicks a value in a dropdown box (form control, not UFM) (6 replies)
  143. Internet Explorer Automation: How to handle connection timeout? (3 replies)
  144. Autofiltering macro - filters text but not the numbers (3 replies)
  145. Help in VBA Coding (do while / loop until) (1 replies)
  146. Solved: Macro to Combine Multiple Workbooks into one Workbook (16 replies)
  147. Export to csv based upon date/time criteria (4 replies)
  148. Select Range to copy Values to (1 replies)
  149. Solved: Timer Panel\Please Wait userform Help (5 replies)
  150. Why is Excel asking me to save......twice? (8 replies)
  151. Solved: view all exceptions (3 replies)
  152. Sum the total value for that column (4 replies)
  153. Solved: Check Box Formula (10 replies)
  154. [SOLVED:] Workbooks.Add (force XLSX format) (1 replies)
  155. VBA for looping cell change (3 replies)
  156. Solved: Grouping Modules? (7 replies)
  157. Code or conditional formatting (9 replies)
  158. Use Excel To Open Word (22 replies)
  159. List of files in directory by date created (11 replies)
  160. Copying Multiple worksheets in Multiple workbooks to one single workbook (4 replies)
  161. Array formula which ignores blanks and duplicates (0 replies)
  162. xla working on xp 2003 / xp 2007 - not working on win7 / 2007 (2 replies)
  163. Autofilter 1 column based on multiple criteria (2 replies)
  164. Find string starting with... (1 replies)
  165. Excel 2010 funcres reference issue (2 replies)
  166. some rows wanted (52 replies)
  167. Looping through cells (contents of cell seperated by commas) and performing vlookups (8 replies)
  168. Insert Rows (1 replies)
  169. Counting the Rows including blank ones (4 replies)
  170. filter upon color (2 replies)
  171. range name / reference (3 replies)
  172. Adding two blank rows between Teams (1 replies)
  173. Solved: help with below formula. (4 replies)
  174. To stop the Printing action when certain criteria is met (0 replies)
  175. Text Function (0 replies)
  176. Help Whit Userform add and delete data Listbox! (1 replies)
  177. Fuzzy matching scoring algorithm (1 replies)
  178. Printing text from textbox and other problems... (0 replies)
  179. Text Function (4 replies)
  180. open 'xl*' files from sub folders without naming them (3 replies)
  181. Time Format Help (3 replies)
  182. Solved: Click to color (14 replies)
  183. Foreign language (1 replies)
  184. Solved: add additional data to word document's bookmark in excel (11 replies)
  185. Expire on Set Date - And Prevent Rolling the Time Back (1 replies)
  186. Chart Series Format Painter (1 replies)
  187. VBA code to find highest and 2nd highest number based in criteria (11 replies)
  188. Help to create an Excel Employee directory by vba (0 replies)
  189. convert to feet and inches (2 replies)
  190. dynamic Scaling for charts (0 replies)
  191. Solved: Removing Empty Rows on Multiple Sheets At The Same Time (3 replies)
  192. Change the image size in terms of the value of a cell (6 replies)
  193. Importing data from multiple workbooks (0 replies)
  194. Name and row count for every .xls file in a directory (1 replies)
  195. Cell format verification (1 replies)
  196. VBA code for pivot-filter (3 replies)
  197. Best (and smart) way to do ListBox Filter (2 replies)
  198. execute macro in another workbook, only works when interactive (3 replies)
  199. Addin auto run (4 replies)
  200. Solved: Listbox Loop in Query update (2 replies)
  201. set print area if needed over multiple pages (1 replies)
  202. Solved: ActiveWorkbook.SaveAs xlsm help! (6 replies)
  203. formula in the end of the page (7 replies)
  204. How to write VBA code to Link to another workbook. (4 replies)
  205. How to stop opening a dialogue box? (4 replies)
  206. [SOLVED:] Solved: How to make Userform input data into a specific (hidden) sheet? (2 replies)
  207. Time and #div/0 error. (1 replies)
  208. Solved: FileSearch (1 replies)
  209. Solved: Recognizing quarters (14 replies)
  210. VBA / Macro -- Retreiving Unique Records (2 replies)
  211. Solved: Prevent Workbook from closing (17 replies)
  212. Create Excel Object 2003 or 2007 (2 replies)
  213. Solved: Changing date from day to Month (9 replies)
  214. Solved: VLOOKUP REFRESH (2 replies)
  215. Loop Help (8 replies)
  216. Need a Macro to do Daily task (8 replies)
  217. Search workbook as you type (3 replies)
  218. Solved: Combining VBA Code to an array (16 replies)
  219. Solved: Basic TOC (4 replies)
  220. File Organizer (1 replies)
  221. Data input into Internet Form with Frames (2 replies)
  222. Question with Forms in VBA (3 replies)
  223. Comparing the string in excel vba (4 replies)
  224. Solved: dont save a window (2 replies)
  225. Solved: sum specific data (6 replies)
  226. Newbie charting help (6 replies)
  227. copy-paste data from multiple files ( .xls ) from multiple folders (4 replies)
  228. Hide two rows at a time!!! (2 replies)
  229. [help]Change from Unicode to word (1 replies)
  230. Cannot paste anything in module (3 replies)
  231. Compare Monthly, Quarterly, YTD, Prior Year, etc Financial Statements (1 replies)
  232. Unable to read formula cells value (5 replies)
  233. data of pending transactions (1 replies)
  234. Solved: Only run this command if Excel version is above 2003 (2 replies)
  235. Solved: Get rid of single rows (2 replies)
  236. How to create a Dynamic List on a Separate Worksheet (3 replies)
  237. Solved: overflow and failed vlookup (2 replies)
  238. VBA Code to perform inner join on 2 worksheets. (3 replies)
  239. Solved: Call the sheets double click event in another workbook (4 replies)
  240. Solved: Excel Formula to determine calls (2 replies)
  241. Solved: Use data in closed workbook (4 replies)
  242. Solved: Need to get Part# from string (12 replies)
  243. Solved: Help Writing VBA code (7 replies)
  244. Passing values to a Font object (8 replies)
  245. Picture input via VBA in Excel 2007 (0 replies)
  246. Question on creating a shared spreadsheet with user login and password (0 replies)
  247. Looking up data in a price file (4 replies)
  248. Send Outlook Email from Excel (3 replies)
  249. Creating a master Data sheet pulling information from each sheet in book (3 replies)
  250. Remove duplicate rows and retain the first duplicate row (5 replies)