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. Control TypeName (3 replies)
  2. Solved: 2000 compatiblity: Pasting to merged cell using macro (2 replies)
  3. Solved: Copy Data from Excel sheet into Another Macro (12 replies)
  4. display a "Please Wait" box while calculating (4 replies)
  5. Solved: Sort 97 (3 replies)
  6. How to detect "no source data" on pivottable (0 replies)
  7. Need help writing a UserForm (0 replies)
  8. Solved: Remove Details From List (5 replies)
  9. Solved: passing cells to a function (4 replies)
  10. Just one click (13 replies)
  11. [SOLVED:] Programatically Print (5 replies)
  12. Solved: Create folders based on values in Column A (4 replies)
  13. Disabling the "Do you want to update..." message (1 replies)
  14. Connecting to MQ Series Queue using EXCEL VBA (2 replies)
  15. Solved: Help showing end date and time. (2 replies)
  16. Solved: Find record and edit field in database (1 replies)
  17. Display alert when target date is less than current date (11 replies)
  18. Solved: calling a macro based on cell value each time it changes (2 replies)
  19. Solved: Pivot table trouble (10 replies)
  20. help needed for copying onto arbitrary named wksheet (2 replies)
  21. Solved: Sheets and Modules Problem Passing Values (2 replies)
  22. User Form - Get data from worksheet (2 replies)
  23. Solved: Manipulating Files on Network Drives (20 replies)
  24. Solved: Userform query (6 replies)
  25. Force user to enable macros and links on worksheet_open object (2 replies)
  26. Pulling numbers from a character string (4 replies)
  27. [SOLVED:] Autofilter contain ctriteria (4 replies)
  28. VBA Macros Help (2 replies)
  29. Extending/ Adjusting CSV files using VBA (17 replies)
  30. Solved: Pivot Table refresh issue (4 replies)
  31. ComboBox converting Date to Number (5 replies)
  32. Protect cell range with password (3 replies)
  33. Solved: CountIf, or maybe something else (9 replies)
  34. Unable to output variable's content to cell (8 replies)
  35. Solved: Self referencing cells? (2 replies)
  36. [SOLVED:] VBA-Group rows, copy to new worksheet (5 replies)
  37. Solved: How to Unhide Col 'A' ? (3 replies)
  38. [SOLVED:] Simple Macro (3 replies)
  39. Solved: Is closing a recordset always necessary? (1 replies)
  40. Uppdate cellformat in cell (1 replies)
  41. Help in saving datas without leaving spaces in between (6 replies)
  42. Enum ToString's (10 replies)
  43. extract certain cell value (2 replies)
  44. Solved: Delete from special character (3 replies)
  45. Solved: Data Validation Drop Down - Changing the parameters (13 replies)
  46. LinkedList Implementation (4 replies)
  47. Testing whether filtering is active. (3 replies)
  48. Working with data from two sheets (5 replies)
  49. Solved: Help needed with Delimiting (7 replies)
  50. Error when Closing a file (1 replies)
  51. Using Arabic on a userform (1 replies)
  52. Use Cell Value in Code (8 replies)
  53. Spreadsheet functions, Add-ins and autocomplete lists (1 replies)
  54. Solved: Problem with ListBox RowSource (7 replies)
  55. Solved: Setting the value in another worksheet (3 replies)
  56. Insert Page Break when values change (3 replies)
  57. Toolbars (not VBA related) (0 replies)
  58. Excel Pivots to PowerPoint (0 replies)
  59. Solved: Splash Effect Object on Userform (7 replies)
  60. Do Static Class Methods Exist In VBA? (1 replies)
  61. import data to ms excel (1 replies)
  62. problem with subtruct (1 replies)
  63. Solved: Fill Down to cells that appear blank (5 replies)
  64. Using ADODB TO Connect To Sybase (3 replies)
  65. Solved: need help (2 replies)
  66. Paste range to fit one page in word. (3 replies)
  67. [SLEEPER:] Clean Files names on a list, compare and signals missing files (3 replies)
  68. Solved: Writing code by code (9 replies)
  69. Insert new row and add Title for new row (5 replies)
  70. find duplicates (5 replies)
  71. Need to change text of .CheckBox through a counter (5 replies)
  72. Offsetting Multiple VLookups with Picklists (13 replies)
  73. Convert String to Range (3 replies)
  74. Free VBA programmingf Add-ins?! (1 replies)
  75. IP Address Location and DNS (2 replies)
  76. Solved: Making a Custom Table (16 replies)
  77. Solved: macro timer (5 replies)
  78. Vertical like through point (4 replies)
  79. Solved: Help with ComboBox not in userform (7 replies)
  80. Solved: quick question formatting column widths (7 replies)
  81. UserForm tables (2 replies)
  82. Solved: Looping Through Cells (5 replies)
  83. Using word file between userForms and readonly (3 replies)
  84. Solved: my desktop / your desktop (5 replies)
  85. Running a Word macro from Excel (3 replies)
  86. Solved: How to add a data label to a bubble in a chart? (2 replies)
  87. Solved: command for Sheets("All")?? (11 replies)
  88. [SOLVED:] Expand/Contract a User Form (3 replies)
  89. Save a single sheet (4 replies)
  90. Solved: File name in status bar (3 replies)
  91. Solved: date format problem with macro.... (6 replies)
  92. Solved: Looping through all workbooks in a folder? (5 replies)
  93. Special type of excel files (3 replies)
  94. [SOLVED:] File Save As (11 replies)
  95. Import a plain file of data into tab (4 replies)
  96. Solved: Formulas, Code, and my ignorance.... (6 replies)
  97. Sorting through two lists (3 replies)
  98. [SLEEPER:] VBA Duplicate Name Check and Calculating the Values (22 replies)
  99. Solved: VBA Macros Problem (20 replies)
  100. [SOLVED:] Add Border to last Row (11 replies)
  101. [SOLVED:] Loop Through WorkSheets: Help Needed (14 replies)
  102. save excel file with different icon (1 replies)
  103. VBA problem (0 replies)
  104. Solved: MS Query and Excel (0 replies)
  105. Excel Formatting in VBA (0 replies)
  106. Excel Formula (11 replies)
  107. Time Capture To Log Files using VBA (8 replies)
  108. Find and subtract (4 replies)
  109. Solved: Sending an email from excel (11 replies)
  110. Solved: Setting a benchmark line in an excel bar graph (3 replies)
  111. [SOLVED:] Return true or false if defined name is there? (2 replies)
  112. VBA to extract data from 2 excels (2 replies)
  113. Solved: macro to open all hyperlink files and save as different sheets in the workbook (5 replies)
  114. [SOLVED:] Versions 97, 2000, & 2003 vbGeneralDate (3 replies)
  115. VBA Simulating a mouse double click (3 replies)
  116. Resize Range Method (4 replies)
  117. Solved: Display result to 3DP? (3 replies)
  118. Excel VBA Export Import Module (0 replies)
  119. Print a document double sided (0 replies)
  120. differenec between two cells - tricky one (2 replies)
  121. Solved: Form & Filter (2 replies)
  122. Create control associated with row (7 replies)
  123. xllastrow range - problem (1 replies)
  124. Seating problem (11 replies)
  125. Solved: How to insert "Are you sure? -> Yes/No" in code (2 replies)
  126. [SOLVED:] Converting Text to Dates... Fast! (7 replies)
  127. Need Creative Input (0 replies)
  128. Named Range Operations (1 replies)
  129. Need help with correct finding/sorting. Explanation and example file enlcosed. (8 replies)
  130. Find and replace multiple items (4 replies)
  131. Solved: SpecialCells bug (8 replies)
  132. [SLEEPER:] How to kill that finger (macro pointer) (5 replies)
  133. Solved: Check for Vowel or Consonant (11 replies)
  134. Code needed: Find or Vlookup (0 replies)
  135. Interesting project? (9 replies)
  136. Solved: Edit KB Encrypt Code (10 replies)
  137. Solved: Create a list dependant on dropdown (7 replies)
  138. Orthoganally adjacent placement. (1 replies)
  139. Syntax Help (3 replies)
  140. copying cells (3 replies)
  141. export txt file data into excel and filter out req'd data (5 replies)
  142. Solved: Send mail to 100 mail address (2 replies)
  143. Solved: JOB: copying data from one sheet to others (3 replies)
  144. Project of the Week (11 replies)
  145. ComboBox retrieval. (1 replies)
  146. Deleting Rows (2 replies)
  147. MULTIPLY LISTBOX QUESTION - RANGE (2 replies)
  148. How to save screen as gif file (9 replies)
  149. Update cell data based on Listbox selection (9 replies)
  150. Solved: Many comboboxes with one name (2 replies)
  151. VBA Save As (1 replies)
  152. Excel Shrink (1 replies)
  153. extract row number (1 replies)
  154. Solved: trouble getting a progress bar working (6 replies)
  155. General Build Questions (2 replies)
  156. Code doesnt work as add-in (7 replies)
  157. Dierctly copying a cell that might be merged (2 replies)
  158. Solved: macro to copy and paste only 5 rows of the filtered data from sheet2 to sheet1 (3 replies)
  159. ADO recordset search (2 replies)
  160. Syntax Help (4 replies)
  161. Buttons thats copy the Caption in a cell (2 replies)
  162. How do i match up two columns of data? (3 replies)
  163. help Excel code (2 replies)
  164. EXCEL HELP (1 replies)
  165. Lookup data in Oracle database (4 replies)
  166. export date from text box to the right sheet (2 replies)
  167. Solved: Advanced help needed :S (4 replies)
  168. List Last nonblank cell in comment box or popup (1 replies)
  169. Calculus graphing (1 replies)
  170. Solved: Reverse code result (9 replies)
  171. Solved: Find a defined name with VBA (2 replies)
  172. Macro running extremely slow (3 replies)
  173. A40 last cell (2 replies)
  174. Solved: Checkbox not allowing me to check (8 replies)
  175. Solved: Useless Data Because of Abbreviations? (15 replies)
  176. [SOLVED:] Run this with a condition (3 replies)
  177. Solved: Print Reports Based on Cell Value (2 replies)
  178. [SOLVED:] User Form - Restrict Entry (5 replies)
  179. Problem with "Fill combobox with ordered list" (8 replies)
  180. Solved: Automating histograms (2 replies)
  181. Code needed for popup message box asking for password to open & use workbook (8 replies)
  182. Solved: Force users to enable macros (4 replies)
  183. 3rd party VBA editor (1 replies)
  184. Chart use array as sourcedata (3 replies)
  185. Macro to check and send data to Array. (4 replies)
  186. select all sheets (13 replies)
  187. How to Cycle through 5 different Pay Scale Possibilities? (16 replies)
  188. Solved: Creating multiple charts in single worksheet vith VBA (5 replies)
  189. Showing Progress in a Label (2 replies)
  190. Solved: SORT of need help (4 replies)
  191. Email help request. (1 replies)
  192. Clear all except first row (2 replies)
  193. Multiple rows slection for operation with rows (4 replies)
  194. How to insert required rows instead of a single row (1 replies)
  195. Fun Excel - Spiral through a range (11 replies)
  196. VBAProject (3 replies)
  197. Solved: workbook protection allowing admin / user access (26 replies)
  198. A simple database project (8 replies)
  199. Solved: strange problem-macro fails every ALTERNATE time!! (7 replies)
  200. Arrays (21 replies)
  201. Help with countif, 2 crteria required (5 replies)
  202. Interesting Excel Question (0 replies)
  203. Not sure if you can help me... Noobie here (5 replies)
  204. [SOLVED:] Pivot Table VBA problem - simple ? (2 replies)
  205. For Each Next Loop problems (3 replies)
  206. sum with conditions (2 replies)
  207. Solved: Multiple tasks for one command button (4 replies)
  208. Solved: simple activation key macro (12 replies)
  209. Solved: Blank Null Space (2 replies)
  210. Solved: Cut Header from a set of data and paste the same next to the Data in C& D Col (1 replies)
  211. Sum cell values on several worksheets (14 replies)
  212. Assigning label caption to a variable (2 replies)
  213. Grab worksheet From Closed Workbook (22 replies)
  214. Amend vba to add file name on save as (7 replies)
  215. Open work sheet (3 replies)
  216. Capture names from 2 arrays and create three new arrays (1 replies)
  217. Check for the Date (11 replies)
  218. Procedure stops running after UserForm.Show (6 replies)
  219. VBA -how to get every second row? (2 replies)
  220. Solved: Consolodate data on one sheet (2 replies)
  221. Solved: macro to save file in my documents (1 replies)
  222. Run-time error and invalid reference (related) (6 replies)
  223. Solved: Last Row in Range (again) (8 replies)
  224. Data referencing problem (10 replies)
  225. About excel vba objects (4 replies)
  226. Revisit Last Accessed Cell (9 replies)
  227. Solved: Renaming / Reorganizing files / directories (6 replies)
  228. Insert row with criteria (5 replies)
  229. VBA: return an item from an array (without using a loop) (7 replies)
  230. Create Chart using VBA function (2 replies)
  231. how to validate cell input for 10 digits only? (4 replies)
  232. Solved: check Ctrl + Shift + Enter array size (4 replies)
  233. Change Pictures (5 replies)
  234. Solved: Dates in Filter macro (4 replies)
  235. Chart Range References (2 replies)
  236. Move rows if conditions meet (6 replies)
  237. Solved: Using Programmed Array in Worksheet Function (12 replies)
  238. Solved: Sum of unique value using sumproduct (6 replies)
  239. Solved: Date + 1 year (1 replies)
  240. Copy/Paste Data turns black (2 replies)
  241. HELP! (18 replies)
  242. Solved: Match 3 cells? (6 replies)
  243. Help using activeX controls in VBA code (5 replies)
  244. Solved: Passing Procedure or Function name as variable (3 replies)
  245. Solved: "Auto" update (5 replies)
  246. Selecting Non contiguous Range (2 replies)
  247. Solved: Help with Dynamic formula (5 replies)
  248. SOLVED: Create multiple named ranges on sheet based on cell values (5 replies)
  249. Solved: Size of Array (5 replies)
  250. Solved: SUMPRODUCT across 4 columns (2 replies)