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: how to make a solved thread, unsolved again? (4 replies)
  2. Use Variable in ComboBox name? (4 replies)
  3. Restrict Data in Cells (2 replies)
  4. Get inner Text string Value (4 replies)
  5. Format of date in text box differs from the corresponding cell. (2 replies)
  6. Solved: Problem with Formula to Determine the Max Row (10 replies)
  7. Data Input in Excel (9 replies)
  8. Locking cells in excel (12 replies)
  9. Control with time (7 replies)
  10. Solved: Copy Large Cells (2 replies)
  11. Solved: User Form / List Box Help Me! (3 replies)
  12. Copying a Module and Updating Links (6 replies)
  13. Solved: 2007 Personal.xlsb info (3 replies)
  14. Solved: Timer Delay (3 replies)
  15. Number of days in current month (15 replies)
  16. Open Workbook based on today's date (2 replies)
  17. save a worksheet (1 replies)
  18. Extend Code To Other Worksheets (12 replies)
  19. Solved: pasting with formulas - problem with macro (6 replies)
  20. Last Row (6 replies)
  21. Import data (3 replies)
  22. Solved: Delete Any Numbers that are less than 1 (12 replies)
  23. Passing a variable into a Private sub (24 replies)
  24. Loop involving list (3 replies)
  25. close all but activeworbook (23 replies)
  26. Copy data from Excel to Internet Explorer (28 replies)
  27. Date Format Error (4 replies)
  28. Solved: XCOPY Command Using VBA? (12 replies)
  29. Solved: view/page break preview (5 replies)
  30. Hiding rows in a protected worksheet.. (3 replies)
  31. Solved: Moving data and deleting duplicate rows (9 replies)
  32. PivotTable.Refresh woes (1 replies)
  33. Cells method advice (1 replies)
  34. Copy Outlook data to Excel (6 replies)
  35. Solved: Using wildcards in a formula (3 replies)
  36. Solved: Update Matched Items (6 replies)
  37. Converting from: Send Key Event to: different event (8 replies)
  38. Copy data from one sheet to another in the same workbook (14 replies)
  39. Sleeper: Autofit without unhiding (9 replies)
  40. Group Cut and Paste (0 replies)
  41. Solved: Precedure that works on one sheet and does not on another one (13 replies)
  42. complex if statement.. need help.. thankyou (4 replies)
  43. Solved: Date in all Caps (4 replies)
  44. conditional addition of row (4 replies)
  45. Solved: Populating a user form, editing the data, then saving it back to the spreadsheet (5 replies)
  46. Shift if "Invoice Date" (4 replies)
  47. Pivot Table Default Selection (0 replies)
  48. Summing largest amounts - Formula limitations? (5 replies)
  49. Compare one cell with a range .... (10 replies)
  50. Dependant comboboxes (2 replies)
  51. SS not accepting dates past 1/20/06 (4 replies)
  52. world war 2 (3 replies)
  53. Automate IE download from jsp web page (5 replies)
  54. Solved: I need to debug, Can you help pls? (13 replies)
  55. zoom in to the pasted area. (5 replies)
  56. Returning External Data from MySQL Server (2 replies)
  57. Solved: Naming Sheets (16 replies)
  58. one sheet print (2 replies)
  59. rename excel files using text in it (14 replies)
  60. coding OptionButton to show message (6 replies)
  61. Browser History to Excel (0 replies)
  62. Solved: Hide my "Personal" (4 replies)
  63. HELP With Code (6 replies)
  64. Images copying to another cell (9 replies)
  65. Solved: Store Application.Vlookup Value in Array? (2 replies)
  66. Solved: Array & cbos? (6 replies)
  67. Getting a feel for excel functions (4 replies)
  68. Solved: Working with Dates (1 replies)
  69. Outlook data checked against a spreadsheet (2 replies)
  70. Solved: delete rows which are not completely filled (8 replies)
  71. Data validation pull down not recognized (18 replies)
  72. Solved: Formula if Product is the same as above (7 replies)
  73. Making a textbox display a default value (4 replies)
  74. Solved: Page break at each change in customer (2 replies)
  75. Code Printing (6 replies)
  76. multi match (2 replies)
  77. Solved: When Application.UserName is blank ... (2 replies)
  78. simple loop backwards (5 replies)
  79. Need help with macro to insert rows and copy data (7 replies)
  80. Solved: assign macros to the controls of a toolbar (29 replies)
  81. Solved: Message Box Obsolete (4 replies)
  82. Adding Controls to Pages programatically (6 replies)
  83. Zygote Assistance: Search by Font, Copy to New Worksheet (6 replies)
  84. CTRL F on more than one WB (8 replies)
  85. Breaking a name into characters (25 replies)
  86. [SOLVED:] Which Runs Quicker??? (11 replies)
  87. Creating Common Connection object to use across many modules (1 replies)
  88. testing/quizzing (3 replies)
  89. convert to number alert msg (3 replies)
  90. Sleeper: Charting question (3 replies)
  91. Solved: Export/Import Range to Text File (11 replies)
  92. Solved: Make add-in compatible with Excel 2007 (8 replies)
  93. Compile error: Variable not defined (22 replies)
  94. Worksheet ReadOnly? (3 replies)
  95. Where is it the written cell???? (8 replies)
  96. Need macro help (18 replies)
  97. Solved: Macro Problem (8 replies)
  98. Solved: Export to Text File (8 replies)
  99. Solved: Cell range as a variable (1 replies)
  100. [SOLVED:] Sheet names in an array (8 replies)
  101. Get Active IE Contents Into Worksheet (11 replies)
  102. Worksheet Formula Finding Duplicate Names? (5 replies)
  103. If null or if is not null question ... (9 replies)
  104. Solved: XLSTART Directory (4 replies)
  105. GetObject method in Excel 2004 for MacOs (2 replies)
  106. Solved: Help with the formula (2 replies)
  107. Solved: send email using outlook to diff people, diiff attachments and using diff email ids (9 replies)
  108. Solved: CLOSE WORBOOK AT SPECIFIED TIME (6 replies)
  109. Solved: Need a blank cell as a result (5 replies)
  110. VLookUp or .... (17 replies)
  111. Solved: excel cursor turns into black box (3 replies)
  112. Mail from Excel via Outlook (4 replies)
  113. [SLEEPER:] Restrict to single selection in Multi select Listbox (5 replies)
  114. Sudoku setup (23 replies)
  115. summ aumont with interesec two index.... (6 replies)
  116. Toolbar... (3 replies)
  117. Excel persisted range to SQL Server 2005 (3 replies)
  118. copy cell content depending on value (4 replies)
  119. Getting the Excel's name from folder! (1 replies)
  120. Counting Clicks? (12 replies)
  121. Create ActiveX Form from Delphi7 (1 replies)
  122. Summary worksheet (5 replies)
  123. [SOLVED:] Line Number in Error Handler (5 replies)
  124. Solved: Opening a doc (4 replies)
  125. Taste of my addin (29 replies)
  126. Solved: Autofilter Question (6 replies)
  127. Solved: bar diagram (28 replies)
  128. Solved: Combo Box Help (5 replies)
  129. Solved: Menu options on Microsoft Visual Basic (2 replies)
  130. IF Formula with colour (5 replies)
  131. Hyperlink - Parent and Child (10 replies)
  132. saving userform textbox as a number in worksheet (12 replies)
  133. Solved: Paste last row into master sheet. (2 replies)
  134. Advice on a sort of client-server app (6 replies)
  135. Highlight formula results that have a blank value (3 replies)
  136. Solved: Get Tabs Back (4 replies)
  137. Solved: Clean up some code (15 replies)
  138. Solved: Get portion of search results (7 replies)
  139. Solved: Formatting headers (2 replies)
  140. Solved: Select Range of all rows (6 replies)
  141. Solved: Can you put a smilie in a msgbox? (2 replies)
  142. Solved: Loop in Excel (5 replies)
  143. Solved: Fixed Cell/Column Width - when reached move to cell below (4 replies)
  144. Solved: Text Compare - pattern match (19 replies)
  145. Solved: find data in a closed workbook? (8 replies)
  146. Solved: Date Formating? (3 replies)
  147. Solved: Selecting a folder interactively (7 replies)
  148. Delete or ClearContents ends sub prematurely (31 replies)
  149. Solved: Sheet Security (19 replies)
  150. Solved: VBA Code to Concatenate (7 replies)
  151. Solved: Email multiple attachments using a column range in excel (10 replies)
  152. Solved: Dynamic placement of buttons (3 replies)
  153. Dodgy array and loop - this might be very bad... (2 replies)
  154. Solved: Data validation cell change - message box (7 replies)
  155. Solved: Message box code (5 replies)
  156. Userforms (3 replies)
  157. Solved: SaveFileName As Concatenated Value (5 replies)
  158. Solved: Selecting Value from List based on Multiple Criteria (8 replies)
  159. Solved: Interest Rate (2 replies)
  160. Copy and pasting format and formula for new range. (8 replies)
  161. Using excel to read pixel color in .bmp files (4 replies)
  162. Inserting names from address list into user form (5 replies)
  163. Hiding Spreadsheets (5 replies)
  164. Worksheet_SelectionChange Now I can't Cut and Paste (1 replies)
  165. Solved: Search and copy question (5 replies)
  166. Solved: Spreadsheet Printing (3 replies)
  167. Problem with Calculated fields in the Pivot Table (1 replies)
  168. Existing data shuts down VBA (18 replies)
  169. Solved: Add new row to spreadsheet (5 replies)
  170. Find Excel workbooks in many SubFolders (5 replies)
  171. Solved: Working with Filtered Data (1 replies)
  172. Solved: Data from Userform to spreadsheet (4 replies)
  173. Menu Editor (19 replies)
  174. msgbox help wanted (9 replies)
  175. Calendar with comments (7 replies)
  176. Fill text to two sheets on entry (3 replies)
  177. Copying data from multiple sheets to one - feedback Req. (5 replies)
  178. Solved: Close Excel? (6 replies)
  179. Logging in problem again. (2 replies)
  180. Solved: Combo Box loses all entries after running code (5 replies)
  181. Converting normal cell into DropDown List (7 replies)
  182. Altering the Series Formula in a Chart (3 replies)
  183. Solved: Nested ifs Check Changed by val (6 replies)
  184. list box (8 replies)
  185. [SOLVED:] Floating button (16 replies)
  186. VB Code for saving a workbook with duplication prevention (13 replies)
  187. Solved: drop down list forced selection (5 replies)
  188. get first blank row and paste formula and format from range (11 replies)
  189. Clean way to create popup help balloons (4 replies)
  190. Solved: Userform updating worksheet incorrectly (4 replies)
  191. [SOLVED:] How to display a special character in a message box? (12 replies)
  192. Conditional transfer of data (3 replies)
  193. VLookup on more than one column (1 replies)
  194. Solved: validation techniques (3 replies)
  195. Solved: Syntax calculation error (7 replies)
  196. Constant (4 replies)
  197. Solved: Forcing a spreadsheet with a read only attribute to reopen as read/write (4 replies)
  198. Solved: Form Controls Vs Active X Controls (15 replies)
  199. Solved: click cell behind picture NOW EDITED (7 replies)
  200. Transfering data form to form (8 replies)
  201. Converting a Column Reference/Address to Points measurement for Shape alignment. (1 replies)
  202. Solved: row counting, pasting on trigger (7 replies)
  203. Solved: CSV File (6 replies)
  204. Extracting data from another file (3 replies)
  205. Get Column Letter (48 replies)
  206. Settings? (14 replies)
  207. extract data from notepad to xls (1 replies)
  208. Solved: From - Option Button & Focus issue (4 replies)
  209. Solved: Multiple instances of VBAProject (1 replies)
  210. Solved: Removing Blanks (18 replies)
  211. Solved: Help with Error Handling (3 replies)
  212. Solved: Duplicates removals! (11 replies)
  213. Set focus in a list box (19 replies)
  214. Cut and Paste Rows to New Worksheet based on date in column - protected worksheet (6 replies)
  215. Advice Needed (5 replies)
  216. User Selected Excel File (18 replies)
  217. Solved: Pop-up with list of sheets and checkboxes? (3 replies)
  218. Buttons Visible/Hidden (8 replies)
  219. FileSystemObject and Subfolders (9 replies)
  220. Solved: Check one range against another (11 replies)
  221. Solved: Perl Conversion (9 replies)
  222. test if more than one year (38 replies)
  223. Updating nested linked files (3 replies)
  224. Solved: Copy rows to 2 different workbooks (21 replies)
  225. Email sheet and cell reference (6 replies)
  226. Solved: Data Entry Control (53 replies)
  227. Solved: Pop-up calendar confusion (15 replies)
  228. Paste format + formula attached to " Add new " Button (3 replies)
  229. auto update link from password protected file (4 replies)
  230. Solved: Quantity at Operation based on In/Out marker (16 replies)
  231. Conditional code or format (No formula) (10 replies)
  232. Solved: Subscript Error (5 replies)
  233. List Boxes (19 replies)
  234. Solved: Help: Need to export image from Excel (10 replies)
  235. ComboBox - Using Combo Boxes to Change/Delete rows (13 replies)
  236. speedy page setup (8 replies)
  237. Solved: quick question (8 replies)
  238. Disable "shift" key (4 replies)
  239. Solved: Vlook up and two combo boxes (3 replies)
  240. Solved: Clearing old data from a table (4 replies)
  241. Solved: Automatic Cell formating (3 replies)
  242. add a description (2 replies)
  243. Solved: Problem with DB Path (2 replies)
  244. Using Case Statement (4 replies)
  245. VBA Code to Auto-Select Rows and Copy to New Worksheet (2 replies)
  246. Solved: Optimize Code (13 replies)
  247. can't get rid of Bold (2 replies)
  248. Solved: Trouble with format of a textbox in a userform (12 replies)
  249. Solved: merge and print with offset (18 replies)
  250. Solved: Preventing renaming sheets (18 replies)