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:] Matching Problem (5 replies)
  2. [SOLVED:] Any Suggestion on how to improve? (6 replies)
  3. [SOLVED:] Counter Help (2 replies)
  4. [SOLVED:] Select range of class error (6 replies)
  5. Sleeper: Filtered Dropdowns (4 replies)
  6. [SOLVED:] AutoFill Question (9 replies)
  7. [SOLVED:] Check if workbook is already open (4 replies)
  8. [SOLVED:] beginner here. (4 replies)
  9. [SOLVED:] Transparent Form Buttons (4 replies)
  10. Sleeper: MAcro Range Help (7 replies)
  11. Sleeper: Combo Box Range problem (2 replies)
  12. [SOLVED:] Is there a way to call up.... (3 replies)
  13. Sleeper: Naming a range and subdividing it (6 replies)
  14. Sleeper: Formula will not see both columns (5 replies)
  15. [SOLVED:] Finding from till end (26 replies)
  16. Sleeper: Copy multiple non-contiguous selections to other workbook (3 replies)
  17. [SOLVED:] Compare two sheets (12 replies)
  18. [SOLVED:] Excel formula re: last entry (3 replies)
  19. [SOLVED:] Search for todays date (4 replies)
  20. Sleeper: Searching Web Data (3 replies)
  21. [SOLVED:] How to get a dropdown box working (8 replies)
  22. [SOLVED:] Custom menu (4 replies)
  23. [SOLVED:] Sheet Protection (3 replies)
  24. [SOLVED:] Help with userform (12 replies)
  25. [SOLVED:] Importing text to columns (1 replies)
  26. [SOLVED:] Missing Microsoft Common Dialog Control (7 replies)
  27. [SOLVED:] Outta Sight Cell Comments (22 replies)
  28. [SOLVED:] Making an AddIn ( Requirements ) (4 replies)
  29. [SOLVED:] Looping Through Sheets Clearing Cells (11 replies)
  30. Sleeper: Unique Array Help / Code cleanup wanted (2 replies)
  31. [SOLVED:] Mutlipage UserForm Referencing (6 replies)
  32. [SOLVED:] Array Question - look for duplicates (7 replies)
  33. Sleeper: Calendar Object Destination Cell Formatting (9 replies)
  34. [SOLVED:] Strange VBE - problem (12 replies)
  35. [SOLVED:] Using a Cell Value as a counter limit (4 replies)
  36. [SOLVED:] Deleting empty rows with a twist (6 replies)
  37. [SOLVED:] Select Case Problem (3 replies)
  38. [SOLVED:] Multiple messages (6 replies)
  39. [SOLVED:] Altering closed workbooks. (2 replies)
  40. Solved: Matching by columns entered (17 replies)
  41. [SOLVED:] Counting data occurances between two non-adjacent columns (5 replies)
  42. [SOLVED:] Better Style for Code (8 replies)
  43. [SOLVED:] Creating Summary Workbook from Multiple Workbooks (17 replies)
  44. [SOLVED:] Clear Textbox with more than 256 characters (2 replies)
  45. [SOLVED:] Help with index and match (1 replies)
  46. [SOLVED:] Removing spaces (16 replies)
  47. Sleeper: couple of Problems (8 replies)
  48. [SOLVED:] VBA Conditional Format Every Other Row (11 replies)
  49. [SOLVED:] Unloading Splash Screen (2 replies)
  50. [SOLVED:] Clear then Recreate existing toolbars? (8 replies)
  51. [SOLVED:] The proper way (7 replies)
  52. [SOLVED:] Clear contents only (3 replies)
  53. [SOLVED:] File Save As (7 replies)
  54. [SOLVED:] User Form Help Again (3 replies)
  55. [SOLVED:] Help with macro (23 replies)
  56. [SOLVED:] Query/Search and Display (13 replies)
  57. Sleeper: Connecting to SQL (2 replies)
  58. [SOLVED:] Call Program problem (7 replies)
  59. [SOLVED:] Find Value? (3 replies)
  60. Sleeper: MSComm1.ComPort = 1 won't debug. (4 replies)
  61. [SOLVED:] Array Base (33 replies)
  62. [SOLVED:] Excel 97 help / SaveCopyAs (2 replies)
  63. Sleeper: One last piece of the pie (1 replies)
  64. [SOLVED:] Animation Error (12 replies)
  65. Sleeper: User form help (1 replies)
  66. Advice: Security of VBA project (32 replies)
  67. [SOLVED:] Trying to place values in a sheet (1 replies)
  68. [SOLVED:] Find-Change-Delete (6 replies)
  69. [SOLVED:] Help!!! I've screwed up my Excel! (13 replies)
  70. [SOLVED:] Relation between two or more "Sub" (16 replies)
  71. [SOLVED:] Disable worksheet copy (2 replies)
  72. [SOLVED:] Update Readonly. (6 replies)
  73. [SOLVED:] msgbox help (4 replies)
  74. [SOLVED:] Userform Search Option (6 replies)
  75. [SOLVED:] Forcing a value in textbox before allowing closing? (2 replies)
  76. [SOLVED:] Automate a column (7 replies)
  77. Advice: Runtime error message (5 replies)
  78. [SOLVED:] multi-column list box (8 replies)
  79. Sleeper: Automate adding radio buttons ? (0 replies)
  80. [SOLVED:] How to work with every cell in an array? (28 replies)
  81. Sleeper: More Form help needed (21 replies)
  82. [SOLVED:] Picture, changes with list selection (3 replies)
  83. Sleeper: If Row is Selected question (3 replies)
  84. [SOLVED:] Open Word from Excel (6 replies)
  85. [SOLVED:] VBA Update Code (6 replies)
  86. [SOLVED:] Beginners question (3 replies)
  87. [SOLVED:] Conditional formatting help needed (4 replies)
  88. [SOLVED:] Declare a Constant Array (4 replies)
  89. [SOLVED:] Listing Names of Subs & Functions (25 replies)
  90. [SLEEPER:] How do I get an OLEObjects check box to call a function when clicked? (VBA) (10 replies)
  91. [SOLVED:] Save problem (1 replies)
  92. Sleeper: ORDERING... (1 replies)
  93. [SOLVED:] .HasPassword property (9 replies)
  94. [SOLVED:] Pivot Table question (4 replies)
  95. [SOLVED:] Return text from a TextBox (2 replies)
  96. Sleeper: SHIFT OR MOVE Cells On The Right... (4 replies)
  97. [SOLVED:] How to select non-contingous cells (5 replies)
  98. [SOLVED:] How does a macro check for cell (fill) colour? (8 replies)
  99. Sleeper: summarizing data from 7 sheets (6 replies)
  100. Solved: Search engine (97 replies)
  101. [SOLVED:] Import rules for text files (4 replies)
  102. [SOLVED:] names in text box (5 replies)
  103. Get username w/ API (15 replies)
  104. [SOLVED:] VBA code Paste Link into PPT (6 replies)
  105. [SOLVED:] Calendar control to pick date (7 replies)
  106. Sleeper: This is crazy - References completely non-functional (6 replies)
  107. [SOLVED:] Printing Workbooks with certain criteria (4 replies)
  108. [SOLVED:] UserForm for input date & time (10 replies)
  109. [SOLVED:] Skip if cell is filled - tab to next blank cell (1 replies)
  110. [SOLVED:] Ghost 2 the return (5 replies)
  111. [SOLVED:] Deselecting cells (13 replies)
  112. [SOLVED:] Delete if Cells are blank (5 replies)
  113. [SOLVED:] Opening workbooks (10 replies)
  114. [SOLVED:] data val box with more than 1 column data (11 replies)
  115. [SOLVED:] Cell reference in worksheet formula??? (5 replies)
  116. [SOLVED:] Clear Contents Leaving Formulae Intact (3 replies)
  117. [SOLVED:] Help with userform combobox and Excel (1 replies)
  118. [SOLVED:] Paste Special Question (2 replies)
  119. [SOLVED:] Trouble with conditional format for entire column (4 replies)
  120. Sleeper: Calculate number of pages per office (3 replies)
  121. [SOLVED:] 2 drop down menus or data val? or a combination! (3 replies)
  122. [SOLVED:] A Different Type of "Timesheet" Query (22 replies)
  123. [SOLVED:] Timesheet Question (11 replies)
  124. Sleeper: drawing tool (1 replies)
  125. [SOLVED:] lists boxes and more (12 replies)
  126. Sleeper: Ghost during the scroll... (0 replies)
  127. [SOLVED:] Conditional Compare Needed/Sort by Color (22 replies)
  128. [SOLVED:] Calendar control (4 replies)
  129. Sleeper: VLOOKUP? (4 replies)
  130. [SOLVED:] GetObject not working (8 replies)
  131. [SOLVED:] Outlook Global Address List (GAL) .. (3 replies)
  132. [SOLVED:] Import from Outlook to Excel (57 replies)
  133. Sleeper: Strange Error Message for Digital Signature (7 replies)
  134. [SOLVED:] List box to populate,command button to highlight & delete (7 replies)
  135. [SOLVED:] Variable Print Header (6 replies)
  136. Sleeper: Creating a template "Installer" (1 replies)
  137. [SOLVED:] Selecting a dynamic range using code (6 replies)
  138. Sleeper: FlexGrid Control, list box (2 replies)
  139. [SOLVED:] excel memory problem? (8 replies)
  140. Sleeper: What screen resolution do you run Excel in (24 replies)
  141. [SOLVED:] Some Answers I have gotten Here (6 replies)
  142. [SOLVED:] Using a combo box as an input box (3 replies)
  143. Sleeping: Selecting Hidden Cells & Auto fill (1 replies)
  144. [SOLVED:] Search & cell reference (8 replies)
  145. [SOLVED:] Open a file(s) (9 replies)
  146. [SOLVED:] Data from userform to worksheet (5 replies)
  147. [SOLVED:] Excel multi Combo Box Problem.. (6 replies)
  148. Sleeper: When references stop... referencing (11 replies)
  149. [SOLVED:] Add Sheet Based On Value (4 replies)
  150. Sleeper: Cannot remove Open password from workbook (22 replies)
  151. Sleeper: Transpose every line (9 replies)
  152. [SOLVED:] Programmatic validation client disconnect error (2 replies)
  153. Sleeper: why?????????? (1 replies)
  154. [SOLVED:] OLE action warning message (3 replies)
  155. [SOLVED:] Colour Cells depending on time (4 replies)
  156. [SOLVED:] Header rows (2 replies)
  157. Solved: Data Validation in xl 2000 (24 replies)
  158. [SOLVED:] Blocking Alphabetical Entries into Textboxes (5 replies)
  159. Sleeper: Rationalize my import / export code (11 replies)
  160. Sleeper: Excel VBA and HTML pages (11 replies)
  161. [SOLVED:] Restrict characters (3 replies)
  162. [SOLVED:] Userform variable (5 replies)
  163. [SOLVED:] A test to see if an entire range is empty (3 replies)
  164. [SOLVED:] Very strange (8 replies)
  165. [SOLVED:] "OnAction" problem (10 replies)
  166. [SOLVED:] Help Help (6 replies)
  167. [SOLVED:] Recorded Macro Lost (2 replies)
  168. Solved: UK Random Lottery Challenge! (20 replies)
  169. [SOLVED:] Printing formulas (on your printer!) (4 replies)
  170. [SOLVED:] Automation Error - Object invoked has disc . . . . (10 replies)
  171. [SOLVED:] Forcing a Save As (7 replies)
  172. [SOLVED:] Automatic Reference to Outlook 9.0 Object Library (9 replies)
  173. Changing Cell Reference to Sheet Name via Formula (10 replies)
  174. [SLEEPER:] Import, Skip Duplicate Records (5 replies)
  175. [SOLVED:] Search By Region (6 replies)
  176. [SOLVED:] Question on my Timesheet Tool (6 replies)
  177. Advice: Excel to Access DB (2 replies)
  178. [SOLVED:] Form value in cell not included in formula (7 replies)
  179. [SOLVED:] Automate Responses to Message Boxes and Input Boxes (9 replies)
  180. [SOLVED:] Delete Hidden Columns (2 replies)
  181. [SOLVED:] Match two columns (2 replies)
  182. [SOLVED:] I know I am asking alot but I'm lost (15 replies)
  183. [SOLVED:] Reducing the code if possible (3 replies)
  184. [SOLVED:] Restricting Save Priveliges (9 replies)
  185. [SOLVED:] Conditional sort and concatenate (2 replies)
  186. [SLEEPER:] Comparing two worksheets with a twist (1 replies)
  187. [SLEEPER:] Match or Lookup commands (3 replies)
  188. [SOLVED:] data cleanup from program (2 replies)
  189. [SOLVED:] Reminder Messages before Workbook Close (8 replies)
  190. [SOLVED:] Adding comment to excel / outlook script (2 replies)
  191. [SOLVED:] Using the AND command (8 replies)
  192. [SOLVED:] Recopy Without Duplicate And Insert In Form (15 replies)
  193. [SOLVED:] Hide / Show worksheets Based on Multiple Criteria (17 replies)
  194. [SOLVED:] Programmatically Erase Data in Merged Cells (19 replies)
  195. [SOLVED:] Msgbox to open when excel closes. (4 replies)
  196. Listing available files and Downloading from FTP site (8 replies)
  197. [SOLVED:] Count Occurrences of Letter w/in Cell? (10 replies)
  198. [SOLVED:] Avoid Loop to Find (and replace) empty cells (7 replies)
  199. Create Import Wizard for Text Files (21 replies)
  200. [SOLVED:] Keeping last entered values in a wizard (21 replies)
  201. [SOLVED:] Formatting Text Boxes in UserForms (10 replies)
  202. [SOLVED:] Range.Cells.Range.Cells (3 replies)
  203. [SOLVED:] Strange error message (6 replies)
  204. [SOLVED:] Interactive Data Entry in Excel (7 replies)
  205. [SOLVED:] Setting range syntax (4 replies)
  206. [SLEEPER:] VBA Script Resources (7 replies)
  207. [SOLVED:] Scroll Bar in Userform Wipes Data in Cells (12 replies)
  208. [SOLVED:] Formatting & Custom Toolbar (3 replies)
  209. [SOLVED:] Help with An Activecell Error (7 replies)
  210. [SOLVED:] Find text in Excel workbook (19 replies)
  211. [SOLVED:] VBE help (3 replies)
  212. [SLEEPER:] Attending the end of macro.... (2 replies)
  213. [SOLVED:] Format in TextBox (4 replies)
  214. [SOLVED:] Adding code to worksheet module (11 replies)
  215. [SOLVED:] Checking and correction values in userforms (3 replies)
  216. [SOLVED:] Positioning of userforms (5 replies)
  217. [SOLVED:] Error when setting Interior ColorIndex (2 replies)
  218. [SLEEPER:] How to encrypt vba code on the fly (14 replies)
  219. [SOLVED:] ComboBox in Command Bar (4 replies)
  220. [SOLVED:] FIND AND INSERT SI NO (3 replies)
  221. [SOLVED:] Header Font (2 replies)
  222. [SOLVED:] VBA App for producing Unit Circle values (1 replies)
  223. [SOLVED:] Excel/VBA crash (7 replies)
  224. [SOLVED:] Formula based on files in directory (1 replies)
  225. [SOLVED:] Create string for Messagebox (10 replies)
  226. [SOLVED:] Odd things between runs... (5 replies)
  227. [SOLVED:] Sum during the importing... (4 replies)
  228. [SOLVED:] Problem running code on a different sheet (7 replies)
  229. [SOLVED:] Stay on Top Userforms for Excel (5 replies)
  230. [SOLVED:] Help with cell display, sheets loop (5 replies)
  231. [SOLVED:] Array Problem (6 replies)
  232. [SOLVED:] Excel day of week conversion (11 replies)
  233. [SOLVED:] Creating a Static Chart (4 replies)
  234. [SLEEPER:] Import of txt file generates error 1004 (2 replies)
  235. [SOLVED:] IF Formula Using Label (4 replies)
  236. [SOLVED:] Unusual Command Buttons (3 replies)
  237. [SOLVED:] Initializing variables (16 replies)
  238. [SOLVED:] Problem with decimals in VBA code (6 replies)
  239. [SOLVED:] Finding Sort Order (1 replies)
  240. [SOLVED:] Auto import/link to CVS data (3 replies)
  241. [SOLVED:] Using Named Ranges (5 replies)
  242. [SLEEPER:] Link Data to Access DB (4 replies)
  243. [SOLVED:] Solved: VBA Reference Missing (4 replies)
  244. [SOLVED:] Insert rows above designated values (9 replies)
  245. [SOLVED:] RegExp help! (8 replies)
  246. [SLEEPER:] Loop (17 replies)
  247. [SOLVED:] Userform scrollbar in frame (2 replies)
  248. [SOLVED:] INDIRECT Reference (1 replies)
  249. [SOLVED:] Protect Individual Cell with Formula? (8 replies)
  250. [SOLVED:] Multipage Focus on UserForm (5 replies)