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. [SOLVED:] CD-ROM - List File Attributes of Directory and Subdirectores (like brettdj's KB) (17 replies)
  2. Sleeper: Using vba variable to create data series for pi and bar graphs (4 replies)
  3. Sleeper: Display correct toolbar icon on starting excel application program (2 replies)
  4. Sleeper: Pivot table summarizing by sum (2 replies)
  5. [SOLVED:] selecting cells (8 replies)
  6. [SOLVED:] Tab Column in VBA Form (6 replies)
  7. [SOLVED:] Copy from multiple sheets paste to new Sheet (7 replies)
  8. Sleeper: Help with macro please (13 replies)
  9. [SOLVED:] Chk sheet names of 2 wrkbk & delete if not matching (2 replies)
  10. Sleeper: TicTacToe Smarts (4 replies)
  11. Sleeper: Adjustment to Hyperlink KB Code (0 replies)
  12. [SOLVED:] Convert Decimal To Binary (21 replies)
  13. Sleeper: Sorting sheets by month from different workbooks into one (3 replies)
  14. [SOLVED:] Need help with date manipulation (6 replies)
  15. Sleeper: Function defintion in comment (2 replies)
  16. [SOLVED:] How to cut one sheet's values and paste it in other sheet? (12 replies)
  17. [SOLVED:] How to insert rows based on different values (6 replies)
  18. [SOLVED:] Problem with "On Error" Not Trapping (8 replies)
  19. [SOLVED:] Formatting MsgBox (7 replies)
  20. [SOLVED:] Adding Time written with Text (11 replies)
  21. Sleeper: Print to different printer based on cell value (10 replies)
  22. [SOLVED:] Automatic launch of a MsgBox (5 replies)
  23. [SOLVED:] Get all sheet names in comboBox of activeworkbook and export when selected (4 replies)
  24. [SOLVED:] How to force the user to make entry(ies) in a specific worksheet before continuing? (11 replies)
  25. Sleeper: User defined range and sheet (2 replies)
  26. [SOLVED:] How to install Calendar Control 11.0 (3 replies)
  27. Sleeper: Sort worksheet by suffix (3 replies)
  28. Sleeper: Accessing an Excel Module (5 replies)
  29. Solved: Conditional Formatting (8 replies)
  30. [SOLVED:] Using Lookup command I think (5 replies)
  31. [SOLVED:] The equivalent for CInt for creating a long (4 replies)
  32. Sleeper: Copy and paste (3 replies)
  33. Sleeper: Word object in Excel (1 replies)
  34. [SOLVED:] VBA Naming Convention; Parameter; ByVal & ByRef; (7 replies)
  35. [SOLVED:] Send Link? (3 replies)
  36. Sleeper: Insert Object (1 replies)
  37. [SOLVED:] Document workbook Properties (7 replies)
  38. Sleeper: Clean and speed up code. (1 replies)
  39. [SOLVED:] Boolean true (6 replies)
  40. Sleeper: Search string 2 (3 replies)
  41. Sleeper: Look right until there are no more cells with content (3 replies)
  42. Sleeper: Input Box asks for input twice! (4 replies)
  43. Sleeper: Filter ListBox Items (6 replies)
  44. Sleeper: Multiple Charts with dynamic ranges (3 replies)
  45. Sleeper: Easy Cell Reference - "Guide" Lines (3 replies)
  46. [SOLVED:] Array Function? (3 replies)
  47. Sleeper: Getting one cell to stay on top of all sheets (3 replies)
  48. [SOLVED:] Help with Lookup (2 replies)
  49. Sleeper: Print Log (6 replies)
  50. [SOLVED:] Pass value to sub in .xla (3 replies)
  51. Sleeper: Dependent lists in order to restrict choices (5 replies)
  52. Sleeper: Close Workbook and via Close Excel (2 replies)
  53. [SOLVED:] Long Loop Time (7 replies)
  54. Sleeper: Multiple Value List Box (13 replies)
  55. [SOLVED:] Sort Alphabetically List Box (3 replies)
  56. Sleeper: Using TextBoxes for Numbers (8 replies)
  57. [SOLVED:] Print Macro (5 replies)
  58. Sleeper: Trigger event when rows are inserted or deleted (5 replies)
  59. [SOLVED:] find a string (4 replies)
  60. [SOLVED:] Range Dynamic Query (7 replies)
  61. [SOLVED:] On error behaviour (2 replies)
  62. [SOLVED:] Populate ListBox from Excel Column (11 replies)
  63. [SOLVED:] Progress Bar / Status Bar (5 replies)
  64. Check for Blank Cells in Column (13 replies)
  65. Sleeper: The sound played upon displaying a msgbox (2 replies)
  66. [SOLVED:] DatePart (Format Standard Date Time) (2 replies)
  67. [SOLVED:] Why is this text and not number? (2 replies)
  68. [SOLVED:] Help linking page (5 replies)
  69. Sleeper: Security issue (6 replies)
  70. [SOLVED:] Home key action (2 replies)
  71. [SOLVED:] Subtotals (0 replies)
  72. [SOLVED:] Checking Checkbox values (8 replies)
  73. [SOLVED:] Passing Variables through sheets (2 replies)
  74. [SOLVED:] am I doing this right ? del sheet if there, else... (11 replies)
  75. [SOLVED:] Macro sends sheets to printer in ascending order, but they're not printed so. (2 replies)
  76. Sleeper: Can not open excel ss (2 replies)
  77. [SOLVED:] Lock Column or Rows (Editing restriction) (2 replies)
  78. [SOLVED:] Forcing Hyperlinks to Open in a new Window (3 replies)
  79. [SOLVED:] VBA: Put Day in Footer/Header (2 replies)
  80. Sleeper: Help with copy import script (4 replies)
  81. [SOLVED:] Help finding the last cell in a range. (8 replies)
  82. [SOLVED:] Add to a stock symbol (3 replies)
  83. [SOLVED:] Font.Size (1 replies)
  84. External Data Help (1 replies)
  85. Sleeper: Transfer to a Different Macro When Stepping Thru Execution (2 replies)
  86. [SOLVED:] Data Validation List (2 replies)
  87. [SOLVED:] Clear cells based on length of cell (6 replies)
  88. Sleeper: Printing to PDF (3 replies)
  89. [SOLVED:] How to link to a file one folder up. (1 replies)
  90. [SOLVED:] need help with VB script, error on cancel.. (2 replies)
  91. [SOLVED:] Worksheet VBA naming (15 replies)
  92. Sleeper: Format summary lines (1 replies)
  93. [SOLVED:] Need Help with a Change Event (7 replies)
  94. Sleeper: Unable to focus on another sheet (4 replies)
  95. [SOLVED:] VBA Like statement (6 replies)
  96. [SOLVED:] colour From LEFT to RIGHT of a cell starting from where a COLON is found (1 replies)
  97. Sleeper: Excel bombs out when I try and Save the workbook (5 replies)
  98. Sleeper: Pivot table naming causing error (2 replies)
  99. [SOLVED:] Help with case statement (16 replies)
  100. [SOLVED:] Select - deselect chkboxes (8 replies)
  101. [SOLVED:] Check sheet names and display MsgBox (8 replies)
  102. Sleeper: Opening Template (1 replies)
  103. [SOLVED:] Test cells for scientific formatting (12 replies)
  104. Sleeper: Loop through range to copy/paste hyperlink (25 replies)
  105. [SOLVED:] Determing Array Size (3 replies)
  106. [SOLVED:] Can't Create New Sheet by "Running" Macro (19 replies)
  107. Solved: Defined Name Errors...Please Interpret (2 replies)
  108. [SOLVED:] Conditionally Color Drop-down Choices (6 replies)
  109. [SOLVED:] Open path given in txtbox1 (5 replies)
  110. [SOLVED:] Find everything to left of ":" (2 replies)
  111. [SOLVED:] Keyboard shortcut to skip through sheets in a open MS Excel workbook (1 replies)
  112. [SOLVED:] Selection.Font.Bold (12 replies)
  113. [SOLVED:] Concantonate Cells (2 replies)
  114. [SOLVED:] Check if the text is ALL UpperCase (UCase) (1 replies)
  115. Solved: cell formatting row wise (3 replies)
  116. [SOLVED:] UDF's (18 replies)
  117. [SOLVED:] Can VBA Statements Be Stacked? (10 replies)
  118. Sleeper: Excel formula (1 replies)
  119. [SOLVED:] Clearing Cond. Fmts from a Range (3 replies)
  120. [SOLVED:] Is there a Scroll Event? (6 replies)
  121. [SOLVED:] Interior.ColorIndex (22 replies)
  122. [SOLVED:] Remove any formatting from cells (5 replies)
  123. Sleeper: Making this code more dynamic (8 replies)
  124. [SOLVED:] Is there a way to retrieve the product key. (2 replies)
  125. [SOLVED:] Macro for Find & Replace (16 replies)
  126. [SOLVED:] Insert VBA code in new Workbook via VBA (8 replies)
  127. [SOLVED:] Chart Limitations (Plotting from Arrays) (4 replies)
  128. [SOLVED:] Click AutoShape and close the workbook w/ option to save. (5 replies)
  129. A (fiendly) Challenge to brettdj (20 replies)
  130. Sleeper: Simple Hyperlink Question (4 replies)
  131. [SOLVED:] Help combine workbooks into 1 (7 replies)
  132. Sleeper: Dates and times (1 replies)
  133. Sleeper: Auto formatting (3 replies)
  134. [SOLVED:] Header (2 replies)
  135. Sleeper: Launching xls via shortcut duplicates macro prompt (11 replies)
  136. [SOLVED:] Problem with simple loop! (16 replies)
  137. Sleeper: Move Cursor Of Second Sheet As Per The First Sheet (5 replies)
  138. Sleeper: Converting Hrs:Mins to general/currency value (1 replies)
  139. [SOLVED:] Border around a range of cells (1 replies)
  140. [SOLVED:] Hiding Rows with a special column? (Please see attached.) (2 replies)
  141. Sleeper: Select and delete (3 replies)
  142. [SOLVED:] Clear contents of cells (34 replies)
  143. sort and create new sheets from CSV data (13 replies)
  144. [SOLVED:] Multidimensional Array Initialization (4 replies)
  145. [SOLVED:] Comparing text to cells but only partial match (2 replies)
  146. [SOLVED:] Transposing Data (9 replies)
  147. [SOLVED:] Copying cells when switching to excel (2 replies)
  148. [SOLVED:] Adding a Column Total to a Printed Report (4 replies)
  149. [SOLVED:] Populating csv. file with text values (4 replies)
  150. [SOLVED:] Total in user form (22 replies)
  151. Sleeper: Read-Only ... Shared Access ... etc Problem (0 replies)
  152. Sleeper: The difference between Hidden and VeryHidden (13 replies)
  153. [SOLVED:] Select given month in various years (5 replies)
  154. [SOLVED:] Cant determine a cells contents (15 replies)
  155. GetOpenFilename multiselect (8 replies)
  156. [SOLVED:] Shared workbook (7 replies)
  157. [SOLVED:] Another sumif - sumproduct delima (2 replies)
  158. Sleeper: Could not find installable ISAM (2 replies)
  159. [SOLVED:] Problem Formatting Date for Display (7 replies)
  160. [SOLVED:] How to NOT Plot a Cell with Formula = Blank (3 replies)
  161. Sleeper: Help with optimizing formulas and workarounds... (4 replies)
  162. Sleeper: Detect and change column width (1 replies)
  163. [SOLVED:] Get sheets name (4 replies)
  164. Solved: display progress bar (20 replies)
  165. [SOLVED:] Delete all non-matching sheet names (3 replies)
  166. [SOLVED:] John Walkenbach's FaceIDs Display (4 replies)
  167. Sleeper: Shuffling Data onto a new Worksheet (6 replies)
  168. Sleeper: Get server name (11 replies)
  169. Sleeper: Copy a range of cells in a for loop (4 replies)
  170. Solved: write cell address in text file through vba (4 replies)
  171. [SOLVED:] open notepad, select all, copy, paste in excel (6 replies)
  172. Sleeper: How to create a sort instruction (1 replies)
  173. [SOLVED:] Excel ** (7 replies)
  174. [SOLVED:] A harder Hyperlink question. (7 replies)
  175. [SOLVED:] Summarize data. VBA CODE (10 replies)
  176. Sleeper: Excel-Outlook-Access Link (5 replies)
  177. [SOLVED:] Can you hyperlink to a hidden sheet? (4 replies)
  178. [SOLVED:] Hyperlink on sheet 1 to sheet 2 in same workbook? (3 replies)
  179. [SOLVED:] Add new record in spreadsheet (1 replies)
  180. [SOLVED:] VBA Code Library (this site) (5 replies)
  181. [SOLVED:] Remove Macros from a workbook with VBA (4 replies)
  182. [SOLVED:] Overflow error 6 (15 replies)
  183. [SOLVED:] Arrange sheet names in sequence (2 replies)
  184. Sleeper: Page footer: page one of x, sub page 1 of 2 (4 replies)
  185. [SOLVED:] Count how many cells have been merged to make one cell. (1 replies)
  186. [SOLVED:] Problem with "ReDim Preserve" (7 replies)
  187. [SOLVED:] Saving as .csv (6 replies)
  188. [SOLVED:] Count the number of cells in a row that are not empty (3 replies)
  189. [SOLVED:] How to fix last row in a worksheet (12 replies)
  190. [SOLVED:] Open UserForm from an Add-In (4 replies)
  191. [SOLVED:] Find the last used column (13 replies)
  192. [SOLVED:] Factorial sub (3 replies)
  193. [SOLVED:] Autohiding Empty Rows. VBA code (8 replies)
  194. [SOLVED:] Hiding rows if the linked cells are unused (10 replies)
  195. Sleeper: ChartSheet Generates Bogus External Reference (1 replies)
  196. [SOLVED:] disable/enable controls (3 replies)
  197. Variable string for cell reference (4 replies)
  198. Solved: Counting sort for multi-dimensional arrays? (20 replies)
  199. Sleeper: Can't interface vb to excel with autosave on (0 replies)
  200. Sleeper: Excel and mysql (1 replies)
  201. [SOLVED:] Compare Sheet1 with Sheet2 (21 replies)
  202. Solved: delete all images from spreadsheet (4 replies)
  203. copying to XML from excel (1 replies)
  204. [SOLVED:] Visual Basic Editor only saves the modules/project sometimes (25 replies)
  205. Sleeper: Copy all workbook contents into a new one (10 replies)
  206. [SOLVED:] Rename sheets (15 replies)
  207. Sleeper: Problems with Solver.XLA (3 replies)
  208. Sleeper: Excel cannot complete this task with available resources. (2 replies)
  209. [SOLVED:] Populate a Listbox from an Access database (27 replies)
  210. Sleeper: Workbook and Forms (3 replies)
  211. [SOLVED:] Search that loops through inputs (8 replies)
  212. [SOLVED:] EXCEL to ACCESS (5 replies)
  213. [SOLVED:] Open next file if not found the one to open (23 replies)
  214. Sleeper: Compare 2 workbook (1 replies)
  215. [SOLVED:] Combining Excel Chart Types (8 replies)
  216. [SOLVED:] Failure Using Logical Operators in Cond. Fmting Formulas (20 replies)
  217. Sleeper: File Exists issue (2 replies)
  218. [SOLVED:] Help to complete a code (30 replies)
  219. [SOLVED:] Help needed with counting formula (3 replies)
  220. [SOLVED:] Change color and text of an Autoshape (3 replies)
  221. Sleeper: Stumped.....Phase calculator (4 replies)
  222. Sleeper: Do Not Update Links - On WB Open (2 replies)
  223. Sleeper: Header Drop Down Box (11 replies)
  224. [SOLVED:] Repeat Rows at the Top (1 replies)
  225. [SOLVED:] Parameters (5 replies)
  226. [SOLVED:] Rows Repeat at Top (1 replies)
  227. Sleeper: Discount Cash Flow (8 replies)
  228. Sleeper: Linking protect to enable=false (6 replies)
  229. [SOLVED:] Check Month and Day (3 replies)
  230. Sleeper: How to delete the 'grand total value' in a pivot table? (1 replies)
  231. [SOLVED:] Delete a sheet IF sheetname doesnt contain the string 'rules' (3 replies)
  232. [SOLVED:] Check the creation date of a file and delete a file when older then... (5 replies)
  233. Solved: Embedded swf (7 replies)
  234. Sleeper : Function SQRT, SUM... (0 replies)
  235. [SOLVED:] Code to organize sheets skipping hidden or specific ones (2 replies)
  236. [SOLVED:] Line break within a cell (4 replies)
  237. [SOLVED:] Loop thru worksheets and run macro (19 replies)
  238. [SOLVED:] Run time error 91 (5 replies)
  239. [SOLVED:] Solved: Get file location in textbook upon clicking button (2 replies)
  240. Sleeper: How to obtain the value of the last row? (10 replies)
  241. [SOLVED:] Delete characters if matching (4 replies)
  242. [SOLVED:] Showing a dialog box during saving (3 replies)
  243. [SOLVED:] Prompting to Save (12 replies)
  244. [SOLVED:] Auto update Excel Charts (3 replies)
  245. Sleeper: VBA - "group by" function (4 replies)
  246. [SOLVED:] Divide a value by a cell (6 replies)
  247. [SOLVED:] Values Adding (6 replies)
  248. Sleeper: 2 Projects (3 replies)
  249. [SOLVED:] Testing multipe counters (20 replies)
  250. Sleeper: Compare Actual vs System (1 replies)