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. Date Problems on VBA Forms (64 replies)
  2. hiding a property of a cell (2 replies)
  3. Solved: Double click to delete as shift column (7 replies)
  4. Solved: Excel photo handler : Malcolm Question (2 replies)
  5. Inserting a New Row (3 replies)
  6. Searching and copying (10 replies)
  7. Solved: activesheet.type always 3? (8 replies)
  8. Extracting Unique Highest Values (8 replies)
  9. Solved: Macro to change file format. (11 replies)
  10. Need help for "if" in excel (4 replies)
  11. calculating the joint variance of two distinct cell ranges (1 replies)
  12. Checking & Deleting (3 replies)
  13. [SOLVED:] Improve my code? (23 replies)
  14. Array Of Variables (9 replies)
  15. Solved: Combination list using VBA (8 replies)
  16. Macro to choose Specific Workbook from a directory (6 replies)
  17. Solved: Total (7 replies)
  18. Floating Comments over Command Button (14 replies)
  19. Solved: deleting rows based on content of cells (4 replies)
  20. Solved: Insert a specific row at the ActiveCell (4 replies)
  21. select/copy cells in a range that contain data (8 replies)
  22. Solved: Unprotect Worksheets (3 replies)
  23. Copy Errors (5 replies)
  24. Solved: InString Function (1 replies)
  25. Format Command Button (Form based) (2 replies)
  26. Add Comment Picture: Maintain Perspective Ratio (7 replies)
  27. changing range (4 replies)
  28. Solved: Problems formatting different date formats (6 replies)
  29. Solved: Frame On Excel (8 replies)
  30. Solved: PLZ HELP...muliple criteria in Excel (5 replies)
  31. Autorun a macro when workbook is open (7 replies)
  32. Reposition Jpg in the middle of the screen? (2 replies)
  33. Solved: Do not know how to approach this one? (13 replies)
  34. New line in tiptext (2 replies)
  35. Solved: Count unique records using multiple criteria (3 replies)
  36. ADODB.Connection Error: Compile Error (4 replies)
  37. Add New Worksheet to Include Date (2 replies)
  38. domain availability (3 replies)
  39. [SOLVED:] Ignore Message Box in excel (2 replies)
  40. Solved: Add data to a closed workbook (20 replies)
  41. Delete Selected Sheet (5 replies)
  42. Logic of multiple search criteria. Help Please! (2 replies)
  43. Need front end for db form?? (10 replies)
  44. Application.calculatefull problems! (17 replies)
  45. copy contents of a template sheet to another sheet (4 replies)
  46. Solved: Calculate 2 cells (3 replies)
  47. Environ Function Help! (9 replies)
  48. Copy excel settings from a pc to another (2 replies)
  49. Else error (2 replies)
  50. Solved: Parsing string elements in an array (7 replies)
  51. excel cannot complete this task with available resources (5 replies)
  52. Replace/Remove word/characters from a String (2 replies)
  53. Extract STATE from address string (3 replies)
  54. Solved: How to prevent user from selecting other background color (3 replies)
  55. listbox multi selection problem (4 replies)
  56. Sheet to Sheet Range To Range Copy (VBA) (1 replies)
  57. VBA Conditional Page breaks (0 replies)
  58. Parse Phone Numbers (Main, Office, Cell) (3 replies)
  59. Solved: Which button is Chosen (3 replies)
  60. Different access for different users (10 replies)
  61. Unique Rows In New Workbook (2 replies)
  62. Solved: Adding and apostophe to the beginning of numbers within cell (5 replies)
  63. Emailing in Excel using VBA Groupwise (0 replies)
  64. Excel 2007 Color Compatibility Issue (0 replies)
  65. Change series of a chart without using relative reference.... (0 replies)
  66. Help needed with this function call (3 replies)
  67. [SOLVED:] stupid questions (5 replies)
  68. Save As File Type 'Options' (3 replies)
  69. Sleeper: Unfinished Macro Copy cells from different Workbooks to a Main Workbook (7 replies)
  70. Excel sends email with low importance (3 replies)
  71. Copy and paste part of data to new workbook and save in specific directory (2 replies)
  72. Excel 2003 speed up code??? (3 replies)
  73. determine if "File Download" window is there (3 replies)
  74. Help!! Excel Data gets cut off when pasting to ppt slide (0 replies)
  75. Solved: Userform query (4 replies)
  76. Solved: Find & Replace problem (6 replies)
  77. Conditional [Color] Formatting not recognized with formula (8 replies)
  78. Problems with Evaluate method in VBA: Variance of the product of two ranges (1 replies)
  79. Excel crasches while opening files with references.addfromfile (0 replies)
  80. Solved: Autofilter (3 replies)
  81. Pivot Table - Blank rows/columns (9 replies)
  82. saving a MSP file to open up in Excel and back (1 replies)
  83. Use vlookup formual in data validation (0 replies)
  84. Chart scaling and adjusting (2 replies)
  85. Solved: Switching the Worksheet Deletion Warning Off? (2 replies)
  86. Can you make VLOOKUPS conditional? (5 replies)
  87. Compare Data from one sheet to another (2 replies)
  88. Solved: Copy input range (2 replies)
  89. Solved: Randomly picked winners (2 replies)
  90. Drop down in one cell & fill another cell (8 replies)
  91. Solved: Help with Excel roster matching... (2 replies)
  92. VBA Split Workbook macro (5 replies)
  93. Solved: Read in Excel, Write out to Text (3 replies)
  94. Apply macros to an other workbook (4 replies)
  95. Conditional count (4 replies)
  96. Solved: Help opening csv files in Excel (23 replies)
  97. Importing data; action when ready (0 replies)
  98. Trying to modify an macros (13 replies)
  99. Select All Data (8 replies)
  100. Data Values in chart (9 replies)
  101. Solved: chart titles with varied font sizes (6 replies)
  102. changing chart colours dynamically (1 replies)
  103. Solved: IF(IsNumber (7 replies)
  104. Compare Private Function help. (1 replies)
  105. Class Project for bnwhite (4 replies)
  106. [SOLVED:] How to check if a shape Exists? (5 replies)
  107. Solved: Auto_Run macro that only auto_runs once (7 replies)
  108. (Limited) Loop Through Sheets. (1 replies)
  109. Solved: Copy cells with no spaces and paste with semi-colon (15 replies)
  110. search for mulitiple text strings, return value (6 replies)
  111. Converting English number Fomat to German number Format (5 replies)
  112. Solved: ActiveCell rw,col (2 replies)
  113. Adding rows and copying cells (3 replies)
  114. Solved: How to insert ToolTips in Cell? (2 replies)
  115. How to write this kind of code (14 replies)
  116. delete row is A(x) is blank (4 replies)
  117. [SOLVED:] List all sheets of opened workbook into ComboBox (8 replies)
  118. Extract entire row based on the cell value (5 replies)
  119. i want to learn VBA (7 replies)
  120. Values from Spreadsheet into Userform Textbox (7 replies)
  121. Comment box listing sheet names from active cell (4 replies)
  122. VBA "ignoring" request to not copy from sheet (2 replies)
  123. [Excel] Data transfer to new file (1 replies)
  124. Linking-updating worksheets? (10 replies)
  125. Solved: Why is the sorted array Not being returned? (9 replies)
  126. Solved: Copy Entire Row based on Cell (4 replies)
  127. VBA Copy/Paste Offset Values Between Sheets (2 replies)
  128. Solved: Why is vba not obeying an if statement to skip a sheet? (2 replies)
  129. Modeless Userform event (6 replies)
  130. Trying to call a amcro on selection of a cell in a range (2 replies)
  131. Populate Array from a range in a closed workbook in vba (4 replies)
  132. "one hundred" converted to 100 (5 replies)
  133. auto populate cell in worksheet (3 replies)
  134. How do I reference the current cell? (2 replies)
  135. Solved: Finding avg of ranges (7 replies)
  136. Wildcard in SUMPRODUCT (5 replies)
  137. Solved: Newbie VBA help in Excel (Moving cells) (6 replies)
  138. Solved: Excel accounting spreadsheet macro (24 replies)
  139. Solved: If loops (7 replies)
  140. [SLEEPER:] Activating Excel VBA References programatically (5 replies)
  141. Regarding Application.ScreenUpdating=False (3 replies)
  142. Solved: Help Basics Input Data (19 replies)
  143. Error (1 replies)
  144. Auto Enable Macro in 2007 (2 replies)
  145. excel 2007 stop pop up (7 replies)
  146. Solved: cycle through rows (6 replies)
  147. InputBox (7 replies)
  148. Solved: Export Shapes to PowerPoint (3 replies)
  149. Solved: VBA active cell (5 replies)
  150. Solved: Splitting cell values into two defferent columns (13 replies)
  151. Solved: Select Cases using two columns (5 replies)
  152. Attached alpha numeric based on criteria (3 replies)
  153. Create Copies of Workbook (4 replies)
  154. Solved: Problem with averaging netdays with criteria (23 replies)
  155. Solved: Get MS Word OptionButton value from Excel VBA (19 replies)
  156. PrintPreview failed (7 replies)
  157. [SOLVED:] How to enter just time in a cell (28 replies)
  158. Select date in page field (4 replies)
  159. Solved: Vlookup and negative numbers (6 replies)
  160. Solved: Range method failed (7 replies)
  161. Problems with Workbook_Beforesave (3 replies)
  162. difficult macro to count values (15 replies)
  163. Solved: Find Max Value across Wkshts and display max in alert (4 replies)
  164. Solved: Adding Formula into Loop (4 replies)
  165. Color fill when >= date entered (5 replies)
  166. Solved: Display Sheet Name If Cell Criteria Is Met (3 replies)
  167. Solved: Change the state of cell by clicking on it (3 replies)
  168. Help with Embedded Add-In Links in a Spreadsheet (4 replies)
  169. cancel button click events (1 replies)
  170. Need help with deleting duplicates (14 replies)
  171. Solved: Adding another column to a listbox? (4 replies)
  172. Array Forumla Help (1 replies)
  173. [SOLVED:] Auto add code to [ThisWorkbook] while running macro from different location (3 replies)
  174. Solved: Run code if workbook abc.xls is open (2 replies)
  175. Loop - usage (10 replies)
  176. Solved: Move and delete row (3 replies)
  177. Solved: Help with SendKeys (4 replies)
  178. Looping through a column (3 replies)
  179. search and delete (1 replies)
  180. Solved: Can't suppress "Do you want to save..." (19 replies)
  181. Custom Menus (3 replies)
  182. Solved: Last Row, CopyPaste (2 replies)
  183. import data to Excel from old accounting system (1 replies)
  184. Solved: Help with IF statements in Excel (13 replies)
  185. Refreshing Pivot Tables (3 replies)
  186. Continued: pivot table counting blank cells in data table (6 replies)
  187. Solved: Selection Triggerred Macro (6 replies)
  188. Solved: Resize to last cell and select (2 replies)
  189. [SOLVED:] Create checkbox (5 replies)
  190. invoice.txt (7 replies)
  191. [SOLVED:] Start from the 2nd row (7 replies)
  192. Macro to Hide/Unhide 3 Sheets (10 replies)
  193. Can't Get This Code to Run in Excel 2007 (5 replies)
  194. [SOLVED:] unselecting all PivotTable rows in a PivotField? (1 replies)
  195. Solved: Copying Rows (9 replies)
  196. Solved: Storing a range as a variable? (6 replies)
  197. If..Then for Empty Column (2 replies)
  198. VBA conditional formatting for rows (more than 3) (9 replies)
  199. Solved: Macro/ Cell referencing and separate sheets (5 replies)
  200. Solved: Excel Recovery Tools (2 replies)
  201. pivot table counting blank cells in data range (5 replies)
  202. recurrence (5 replies)
  203. Opening Data File automatically (8 replies)
  204. [SOLVED:] Cell value unseen on first open (2 replies)
  205. Excel bar Chart invisible (5 replies)
  206. Solved: Loop in Column P to Convert value (4 replies)
  207. Solved: Listbox Format (3 replies)
  208. Solved: How to auto count a data (4 replies)
  209. Solved: Advice, please - VBA vs. Visual Basic.Net (16 replies)
  210. Solved: Week No Formula (13 replies)
  211. Solved: Find String (7 replies)
  212. Command button to save and add data? (4 replies)
  213. Solved: SysTray - reduce form or workbook to... (8 replies)
  214. Jump to another cell on a different sheet (10 replies)
  215. Problem with Excel... (3 replies)
  216. Copy a range ? (2 replies)
  217. Using Trendline Formulae (1 replies)
  218. [SOLVED:] Seconds Counter (42 replies)
  219. Append data from EXCEL to SQL Server (8 replies)
  220. Solved: Define number of cells that should contain data (8 replies)
  221. Display info from Spreadsheet in listbox (30 replies)
  222. Playing Midi Files in VBA (1 replies)
  223. Writing a Macro for Checkbox Form (3 replies)
  224. Macro for color fill (7 replies)
  225. Solved: Working with two workbooks (3 replies)
  226. Counting Multiple Cells (3 replies)
  227. Using Excel with ACT (3 replies)
  228. Solved: Saving files increment of 1 (7 replies)
  229. Add macro button to worksheet - tricky (1 replies)
  230. Solved: Concatenate multiple un-adjacent columns (17 replies)
  231. open charts from list (0 replies)
  232. Code required to remove a button (4 replies)
  233. Solved: VBA: Left & Find function Error (6 replies)
  234. Solved: Option Buttons (13 replies)
  235. Solved: customized macro button (1 replies)
  236. Solved: Find / Replace not working - why? (3 replies)
  237. Auto Filter .... (3 replies)
  238. Solved: Choosen some checkbox (5 replies)
  239. Solved: loop (2 replies)
  240. Solved: Merging Data from 2 Sheets (0 replies)
  241. Solved: Loading a listbox with sheet names (4 replies)
  242. Insert Picture into Comment (0 replies)
  243. Solved: Application.Calculation . . . Explain Please (4 replies)
  244. Copy Data from table based on Criteria (5 replies)
  245. Solved: Dual Worksheet Duplicates (10 replies)
  246. Combining HTML and text box entry into message body (1 replies)
  247. Insert rows condition but ingore the blank cells. (2 replies)
  248. How to export random samples from multiple sheets to a new workbook (1 replies)
  249. Finding Max or Large in non contiguos range (5 replies)
  250. OPEN TO SPECIFIC SHEET (2 replies)