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. Add values when checkbox is checked. (5 replies)
  2. Random Records (1 replies)
  3. Remoing Pivot Items (0 replies)
  4. MaxLength for Textbox (10 replies)
  5. button works funny, why?? (5 replies)
  6. multiple workbooks--take values and match (5 replies)
  7. Clear cell value after data entry (4 replies)
  8. Help: 3D chart (0 replies)
  9. Verification on my defining variable and small piece of code (5 replies)
  10. drop down lists (5 replies)
  11. Automating Exporting Records (9 replies)
  12. search for a file in a folder using rows of data in an excel file (7 replies)
  13. Displaying Image on a Userform (2 replies)
  14. principle component analysis for excel (8 replies)
  15. Filter Issue (1 replies)
  16. Solved: Using Page Field to Create Multiple Sheets in Pivot Table (3 replies)
  17. runtime error 13??? (2 replies)
  18. Create Bandings within a Pivot Table (0 replies)
  19. xlDialogSaveAs: Lock it to a specific directory? (0 replies)
  20. Help with Password (1 replies)
  21. Solved: interacting with other applications (4 replies)
  22. Solved: Sub v Function (5 replies)
  23. Solved: Format Cell with Upper Case (6 replies)
  24. Vlookup Macro that updates values by file by date. (4 replies)
  25. Solved: Run macro only once within 20 hours (5 replies)
  26. Solved: Extract specific data from a worksheet. (2 replies)
  27. Using Windows Media Player in VBA (0 replies)
  28. [SLEEPER:] Copy, Paste, Then Save (7 replies)
  29. Vlookup is this what I need??? (15 replies)
  30. [SOLVED:] VB to find first populated number & then sum range of cells (7 replies)
  31. String Cell Formula from Column Headings (1 replies)
  32. Solved: Tricky copying to a new Sheet - Urgent Help Needed Please! Thanks!!! (0 replies)
  33. Solved: more chart questions....defining specific ranges to axes (2 replies)
  34. [SOLVED:] Vlookup for Duplicates (8 replies)
  35. Issues With Adding TextBox (12 replies)
  36. Text file from Excel - MESSY! HELP! (3 replies)
  37. Opening Up a PDF Document via a Command Button (7 replies)
  38. Clear ComboBox (1 replies)
  39. Stop Webpage from popping up (0 replies)
  40. Validate Data entered in UserForm (1 replies)
  41. Sleeper: Preventing Duplicate data entry in a userform (24 replies)
  42. Is Excel 2007 back compatible to 100%? (10 replies)
  43. [SOLVED:] Defining both axes titles for charts (3 replies)
  44. Solved: Match Values in Column A and Column B and if matched copy entire row (0 replies)
  45. List sub folder permission groups (0 replies)
  46. Solved: Pivotable.pivotfield.pivotitem problem (8 replies)
  47. Deleting all named ranges except "Print_Area" (4 replies)
  48. Solved: count the cells with fill color (3 replies)
  49. Delete Columns if value equals zero (2 replies)
  50. Color cells based on values (9 replies)
  51. Query for Help (4 replies)
  52. Solved: Remove all lines (2 replies)
  53. linking problem.. (2 replies)
  54. Solved: Break the password protecting the code (1 replies)
  55. Solved: worksheet counting (3 replies)
  56. Macro for Tracing Precents and Formula Auditing (2 replies)
  57. calculating slope (3 replies)
  58. Solved: changing plot area of chart to have gradient look (3 replies)
  59. Change attributes of a folders contents (2 replies)
  60. msgbox help wanted (6 replies)
  61. Opening Access From Excel Macro - Security Warning (1 replies)
  62. Return Missing Lookups (5 replies)
  63. Solved: Help: Time Scale for chart (6 replies)
  64. User Defined Folder For hyperlink in Excel (1 replies)
  65. Help using list boxes (4 replies)
  66. Delete row if value does not exist (6 replies)
  67. Application.FileSearch and Excel 2007 problem (2 replies)
  68. How to efficiently handle sets? (6 replies)
  69. a formula in footer (1 replies)
  70. Changing the contents of the hint in a graph (4 replies)
  71. two questions.....public variables and naming charts (2 replies)
  72. Solved: using just the cells with relevent data in to plot graph... (10 replies)
  73. Solved: when closing file and users click on NO (do you want to save...)...ask one more time (3 replies)
  74. Solved: how to delete some range with values on another sheet (4 replies)
  75. Solved: phantom name ranges (11 replies)
  76. Embedding Word into Excel Form (1 replies)
  77. [SOLVED:] Check to see if macro has run (10 replies)
  78. Comparing 2 sheets (1 replies)
  79. form - cursor position - Excel 2007 (9 replies)
  80. Help with filling data in relative cells (1 replies)
  81. elements in an array (27 replies)
  82. Pivot Table processing problem (0 replies)
  83. chart background divided into segments (2 replies)
  84. Excel link in webpage works, but saves in temp file instead of original location (6 replies)
  85. Excelk VB code (8 replies)
  86. when last day in month and time is 23:55 then copy cells??? (8 replies)
  87. Selecting A Cell - In A Column By its heading (2 replies)
  88. Solved: Print problem (6 replies)
  89. Vague Drop Down Menu Question - Sorry! (5 replies)
  90. Autofilling (2 replies)
  91. Help protecting pivot tables with exceptions (0 replies)
  92. Dynamic Bespoke Chart (2 replies)
  93. UPDATE HYPERLIck (11 replies)
  94. Sending emails on behalf of a group - VBA - Lotus Notes (0 replies)
  95. Solved: Change text to numbers for different sheets and workbooks (6 replies)
  96. [SOLVED:] Form Navigation Buttons (9 replies)
  97. [SOLVED:] Excel Security (2 replies)
  98. code problem (8 replies)
  99. Authenticating against Active Directory AD usign Kerberso? (1 replies)
  100. solver and excell 2007 (2 replies)
  101. Update table reference while code runs (0 replies)
  102. Dynamic listbox, help! Stressed... (4 replies)
  103. Combobox ListFillRange (7 replies)
  104. Solved: Setting the print area for used rows and columns (4 replies)
  105. TREE hYPERLICK UPDATE (5 replies)
  106. Solved: Change Date Format VBA (2 replies)
  107. Assign picture to Image Control (2 replies)
  108. Solved: copy a cell value not the formula?? (12 replies)
  109. Returning RecordSet Objects from Functions (2 replies)
  110. Solved: Font color for string (2 replies)
  111. Find Column Difference (3 replies)
  112. [SLEEPER:] Searching Words in a String (4 replies)
  113. Solved: Transfer data from one sheet to another based on criteria (3 replies)
  114. Solved: averaging variable sized ranges (11 replies)
  115. Print PDF script: check for pdf printer and give dialogue to choose? (18 replies)
  116. WebQuery difficulties (6 replies)
  117. Color cells (1 replies)
  118. Solved: Excel Comments item (2 replies)
  119. Solved: For loop for Large Data (2 replies)
  120. Solved: Run Once Then Delete Code (9 replies)
  121. look down column and paste values across cells (1 replies)
  122. Cell Incrementation (15 replies)
  123. Solved: select or activate fail when code is active? (10 replies)
  124. copy offset and paste loop (2 replies)
  125. Date Format US/UK (0 replies)
  126. [SOLVED:] WEEK in MONTH (20 replies)
  127. Solved: Minimize user form (7 replies)
  128. Solved: button problems... some extra wishes... (9 replies)
  129. Solved: Box Next To Column A And Above Row 1... (3 replies)
  130. Copy/Paste/Delete based on Date (4 replies)
  131. Generate Numbers Based On Month, Year And four Digit Number (4 replies)
  132. find the range in a sheet (9 replies)
  133. insert picture in cell (4 replies)
  134. Insert Rows (17 replies)
  135. Need help with command button (9 replies)
  136. Solved: listing errors in data, using Vlookup (3 replies)
  137. Solved: MsgBox not big enough? (13 replies)
  138. not a VBA question but please help (6 replies)
  139. sum every n-th row (4 replies)
  140. Solved: Barcode Help (6 replies)
  141. restricting copy paste so it won't copy formatting (3 replies)
  142. Adding/copying tables base on Input Data (1 replies)
  143. Solved: Understanding what used in this file (6 replies)
  144. Field cannot be updated (7 replies)
  145. Converting Excel 97/2000 to Excel XP/2003 (3 replies)
  146. Pics not being copied (1 replies)
  147. Solved: Formula with ranges based on variables (2 replies)
  148. optimization question (6 replies)
  149. Solved: Early Binding ADODB from Excel (7 replies)
  150. Solved: Recording changes in values (1 replies)
  151. [SOLVED:] Using XLQ in VBA (7 replies)
  152. Solved: Image in Comment box problem that Microsoft couldn't help with (7 replies)
  153. hide every n-th row (8 replies)
  154. Querying Access from Excel using VBA (4 replies)
  155. User form hotkeys (9 replies)
  156. call a sub from a combo box (9 replies)
  157. Solved: Sending Email Flagged High Priority (1 replies)
  158. Copy values from several workbooks to one workbook (7 replies)
  159. Solved: if sheet not found end sub, if found goto (18 replies)
  160. Help: The same text but can not error return by VlookUp (2 replies)
  161. Solved: Adding extra vba code (5 replies)
  162. Solved: Prompt user for a range of cells to copy (4 replies)
  163. Solved: Organize inconsistant data from 2 columns to 1 column on different sheet (6 replies)
  164. Solved: onkey event, toggle? (7 replies)
  165. Solved: How to Copy Values from another worksheet to Activeworksheet (5 replies)
  166. How to sort numbers in asceding order? (11 replies)
  167. Tricky IF() use (9 replies)
  168. Solved: Sorten Recorded Macro (17 replies)
  169. Delete all rows after.... (4 replies)
  170. Dealing with Ties when using Vlookup with Rank. (1 replies)
  171. regrouping data (11 replies)
  172. Task complete...note of thanks. (2 replies)
  173. Validation form concept (3 replies)
  174. Visible Timer On Form (6 replies)
  175. Solved: Import multiple text files as new worksheets (11 replies)
  176. Progress Bar - extend run time (12 replies)
  177. Solved: VBA CODE FOR PASTE VALUES (8 replies)
  178. [SOLVED:] Can't open specific Sheet from Closed Workbook, i get eror's! PLEASE HELP!?! (12 replies)
  179. sql server VBA help (3 replies)
  180. ListView ItemSelectionChanged (0 replies)
  181. Solved: Move row based on text (4 replies)
  182. Solved: Simple Error Handling Help (15 replies)
  183. Looping a combobox (13 replies)
  184. Maximize Excel window (2 replies)
  185. Code to Loop Through Columns & Perform Action (1 replies)
  186. Solved: Use of Daverage in VBA (11 replies)
  187. Solved: newbie question regarding averaging arrays based on dates (14 replies)
  188. Format Cell in Excel 2000 (5 replies)
  189. Solved: use array to speed up copy and paste (6 replies)
  190. Solved: Number format (20 replies)
  191. Interrogating jpeg/jpg files (4 replies)
  192. Compile error: User-defined type not defined (9 replies)
  193. Loops and formulas (4 replies)
  194. on click a cell and copy to another cell (4 replies)
  195. Applying Title and current date to new file (1 replies)
  196. Solved: Left Lookup (5 replies)
  197. Solved: Copy down to blank cells? (10 replies)
  198. Selecting specific sheets to print (12 replies)
  199. Solved: Copying from one workbook to another WITHOUT seeing source (2 replies)
  200. Solved: Quick Formatting Question - Text Alignment (7 replies)
  201. Solved: Offset To Add Formula (4 replies)
  202. [SLEEPER:] Run code at specified time each day (6 replies)
  203. Solved: Excel crashes when Force Macros VBA is used (12 replies)
  204. Solved: Display userform pause code (3 replies)
  205. Functions on filtered rows (5 replies)
  206. URGENT!!! How to detect whether a value is convertible or not using the Cxxx() (6 replies)
  207. Solved: newbie wanting to know how to selct a variable range in VBA (7 replies)
  208. Dynamic OptionButton Validation (20 replies)
  209. Solved: More scanning help (4 replies)
  210. Solved: Change text to hyperlink (17 replies)
  211. [SLEEPER:] Validating Cells... (6 replies)
  212. Solved: Change Event? (12 replies)
  213. Tempermental Code seems protection related (5 replies)
  214. How to "tag" worksheet for later identification (10 replies)
  215. EMAIL command button (5 replies)
  216. Solved: Left Function (5 replies)
  217. URGENT!! Detecting Types of Errors as resulted from Cell Formulas (7 replies)
  218. overriding replace dialog box in saveAs method (1 replies)
  219. [SOLVED:] Using excel to send email through lotus notes - variable data and open/close notes (2 replies)
  220. changing textbox colour? (6 replies)
  221. CommandBox duel command? (8 replies)
  222. Copy data into Selective Range (0 replies)
  223. Solved: Fill Formula down & paste values up (3 replies)
  224. add a shortcut menu to excel (1 replies)
  225. Conditional formatting formula required for excel (6 replies)
  226. Solved: convert worksheet_change to module sub (5 replies)
  227. [SOLVED:] Single Command Button on Multipage (3 replies)
  228. One named range for the same range on 2 or more noncontiguous worksheets (3 replies)
  229. Solved: Help on Concatenate 2 cells under one drop down???? (1 replies)
  230. Display adjacent cell search results (4 replies)
  231. Emailing disjoint cells (1 replies)
  232. Defining sourcerange (10 replies)
  233. Solved: VBA write to a protected cell and I have the password (3 replies)
  234. keep text formating when transfering text from text box to cell (1 replies)
  235. Solved: combining lists into a string (4 replies)
  236. Write in a protected closed workbook (18 replies)
  237. Excel conditional formatting (5 replies)
  238. Solved: Delete pages (3 replies)
  239. Delete a row with the oldest date when project numbers match (12 replies)
  240. Solved: Selection of worksheet (6 replies)
  241. Code; Why Will it not work on any other sheet? (2 replies)
  242. How to search on two or more sheets? (5 replies)
  243. Solved: ComboBox error: Invalid property value (4 replies)
  244. Finding with userform (4 replies)
  245. Solved: openfile dialog retain openned name in variable (7 replies)
  246. Solved: Bulk entry of FormulaR1C1 problem (13 replies)
  247. Assign Macro to ComboBox?? (9 replies)
  248. Help Required with inputing data to excel worksheet (2 replies)
  249. Delete row on condition (18 replies)
  250. Multiple And Condition is Returning Wrong Answer (14 replies)