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. color grid (3 replies)
  2. Sleeper: Using a UDF in Multiple Worksheets (4 replies)
  3. Solved: VBA to identify duplicate entry and insert row to other worksheet (14 replies)
  4. Solved: Run an access macro thru excel (4 replies)
  5. Excel VBA to check if multiple worksheets exist (6 replies)
  6. VBA userForm: changing images (6 replies)
  7. help with "select method of range class failed" (3 replies)
  8. How to construct VLOOKUP in VBA? (4 replies)
  9. Sleeper: Distribution of data among employees (2 replies)
  10. How to put together caption (2 replies)
  11. Solved: SOAP Action fails (5 replies)
  12. Counting Data between Decades (1 replies)
  13. Parse SAS LOG using RegExp (10 replies)
  14. Functions can change some properties? (5 replies)
  15. Print Multiple Sheets as Word Docs (7 replies)
  16. Solved: Check if cell has data validation (2 replies)
  17. Find last row, insert row retaining format of last line and repeat for named tabs (1 replies)
  18. How to end unlimited cycle? (6 replies)
  19. Solved: Highlight the line when certain cell is selected (10 replies)
  20. Global Error Handling (11 replies)
  21. Enter seperate cells in chart (4 replies)
  22. A special calculation (8 replies)
  23. Solved: insert rows based on cell value (6 replies)
  24. VBA help needed :( (14 replies)
  25. Solved: Subtracting Numbers with Sheets 1/2 data (6 replies)
  26. Solved: Prevent the user from seing some worksheets (4 replies)
  27. Folder/Subfolder list help. (16 replies)
  28. Solved: Prevent the user from bypassing Data Validation (10 replies)
  29. Solved: Find, Cut, Move & Copy issue (3 replies)
  30. IMPORT *.LOG file into textbox + autosize (9 replies)
  31. Derived classes in VBA (1 replies)
  32. VBA Running Excel 2003 when you have 2007 Installed (1 replies)
  33. Solved: Extend range of cells from active cells (6 replies)
  34. Solved: External Data Requery (3 replies)
  35. Solved: What formula or vba code for this case (5 replies)
  36. Printing time period based on usr input. (10 replies)
  37. Object-oriented programming in VBA (5 replies)
  38. Solved: Sheet Code is not working correctly (8 replies)
  39. Solved: 2007 Application.Quit (2 replies)
  40. Macro to Loop Through a Repetitive Task? (7 replies)
  41. Read a Mainframe Dataset (PDS) using VBA (6 replies)
  42. Referring to pasted shapes / pictures (10 replies)
  43. Viewing VBA when passwd protected (1 replies)
  44. Opening File in VBA code (1 replies)
  45. enter seperate cells in chart (0 replies)
  46. Sleeper: Multiple pictures in one section in the header (0 replies)
  47. Clean the working mess (5 replies)
  48. Solved: Fade Away Userform doesnt work properly when closing userform (9 replies)
  49. Solved: Setting Dynamic Print Range (3 replies)
  50. Solved: Macros across workbboks (12 replies)
  51. Dynamic Validation Not working? (4 replies)
  52. Solved: Generate a random string of letters (6 replies)
  53. Solved: How can I return cell value via worksheet name (2 replies)
  54. Converting number to text (7 replies)
  55. auto-complete scroll bar (2 replies)
  56. Solved: Soap: need refresher (5 replies)
  57. Strange problem with excel chart (0 replies)
  58. Solved: Visible Range after AutoFilter (5 replies)
  59. VBA Project Password (2 replies)
  60. [SOLVED:] Sort Sheets in ascending order (2 replies)
  61. change code help (1 replies)
  62. Solved: creating new workbook/searching for wkbook (14 replies)
  63. Grey out menu item (5 replies)
  64. Solved: public functions (1 replies)
  65. Solved: Test before paste special (8 replies)
  66. Solved: Can I insert a copied row with a macro? (9 replies)
  67. Code help (4 replies)
  68. Adhoc SumIf on variable criteria (2 replies)
  69. Using NORMSDIST() Function in VBA (4 replies)
  70. PDF all worksheets and print (1 replies)
  71. Problem with hyperlink (15 replies)
  72. Solved: make sure 2 values always equal (6 replies)
  73. [SLEEPER:] Prevent user from viewing the code (1 replies)
  74. Solved: 6 dependant drop down boxes (12 replies)
  75. Solved: Load IE to Excel Sheet (5 replies)
  76. Help with USerForm Contain MultiPages (0 replies)
  77. Solved: Protect UserForm but not module (1 replies)
  78. Solved: How get TargetPath of .lnk or .url shortcut files? (8 replies)
  79. Excel Print Specific word document page (5 replies)
  80. Cycle thru worksheets and import shape according to dynamic values (3 replies)
  81. Excel 2003 Query Sharepoint List (0 replies)
  82. Solved: Rearranging data (9 replies)
  83. Excel Chart (0 replies)
  84. Excel Visible/Invisible (4 replies)
  85. Solved: Excel 2003: Disable screen refresh during intensive chart updating (8 replies)
  86. How to write a click event from a list box??? (2 replies)
  87. Two add-ins for one custom ribbon tab (2 replies)
  88. [SOLVED:] Excel to World find Wholeword (1 replies)
  89. IF Formula (0 replies)
  90. Write to text file question (15 replies)
  91. vlookup and hlookup on multiple criteria (12 replies)
  92. sumifs in VBA (5 replies)
  93. Prevent variable from being initialized (2 replies)
  94. Find maximum and minimum values each day (2 replies)
  95. Solved: Avoiding a <type mismatch> error using IsError ? (4 replies)
  96. Solved: Problem in personal worksheet (18 replies)
  97. redefinition type in VBA (1 replies)
  98. dates in columns (2 replies)
  99. refresh all on protected sheet (7 replies)
  100. Advice: Redefine type of variable (3 replies)
  101. Solved: Find Value in Column And Paste data into it (15 replies)
  102. Solved: Insert Image from Userform Commandbutton. (6 replies)
  103. Solved: Identify column or number (6 replies)
  104. test of KB code on Disable Cut, Copy, Paste (6 replies)
  105. Solved: VLOOKUP problem (2 replies)
  106. Solved: move cursor to row X in active column (14 replies)
  107. Solved: Adding a button to a commandbar (Excel '97) (2 replies)
  108. Solved: ListFillRange from another workbook (4 replies)
  109. Vlookup problem (0 replies)
  110. VBA code to use a hyperlink to email file (3 replies)
  111. Any way to prevent deleting a specific WS? (5 replies)
  112. Disable Cut, Copy, Paste (2 replies)
  113. Problem with deleting empty cells (2 replies)
  114. Conditional formatting question (4 replies)
  115. List File Attributes of Directory and Sub-directories (6 replies)
  116. Solved: color code range (4 replies)
  117. VBA to click OK in Javascript popup box? (1 replies)
  118. Solved: Creating directories from within excel? (2 replies)
  119. Time Out and auto close after expired time (1 replies)
  120. Solved: Filtering multiple worksheets based on master worksheet (1 replies)
  121. Force users to enable macros in a workbook (5 replies)
  122. Probably simple VBA issue (5 replies)
  123. Solved: ADO Assistance (Excel into Access) ('97 versions) (7 replies)
  124. Tough VBA data pulling from IE to Excel coding question (1 replies)
  125. Detect Change in Row . . (4 replies)
  126. Data number, symbols, sectors (3 replies)
  127. Input Line (11 replies)
  128. Solved: changing cell value/mapping (3 replies)
  129. VBA issue exporting Chart to Word (1 replies)
  130. SPLIT TEXT BY MACROS (8 replies)
  131. Moving files from one folder to another (6 replies)
  132. Add dynamic subtotals and then hide all blank rows (2 replies)
  133. Saving an activeworkbook as a time stamp (2 replies)
  134. anchor picture to cell (3 replies)
  135. VBA to perform specific instruction upon identification of duplicate entries (1 replies)
  136. selecting a range from a user defined reference in another sheet (7 replies)
  137. Excel VB Programing (8 replies)
  138. Drop down validation using array (2 replies)
  139. excel to powerpoint (1 replies)
  140. Solved: Correct method for a second FindThis criteria (13 replies)
  141. Solved: Getb Special Folders with Enums (17 replies)
  142. Controlling powerpoint from excel (1 replies)
  143. VB Button Code, HELP (1 replies)
  144. Embeding HTML in Excel (1 replies)
  145. need VB solution for comparing trendlines (1 replies)
  146. Run code when cell changes (1 replies)
  147. Solved: Okay, here is a wierd one for you!!! (11 replies)
  148. VB Formula Assistance needed (3 replies)
  149. Solved: Excel chart (6 replies)
  150. VBA to adjust print area based on UsedRange (3 replies)
  151. For a website, are Excel scripts better than other programming language scripts? (7 replies)
  152. VB Stopwatch Code (3 replies)
  153. vlookup probs (3 replies)
  154. Solved: Simple error message (6 replies)
  155. Design of set up (9 replies)
  156. Solved: Lost Workbook (4 replies)
  157. vba open workbooks (2 replies)
  158. Solved: Can macro let user click to choose workbook (23 replies)
  159. Convert Sheet To PDF Before Emailing (7 replies)
  160. SpaceChart plot does not show up (0 replies)
  161. VBA to extract information from Pivot Table (13 replies)
  162. Multiple nested arrays to fill from a worksheet (4 replies)
  163. basic syntax query (2 replies)
  164. sum then devide by a hundred (2 replies)
  165. Trying to create a chart without a Legend (0 replies)
  166. "Should Cost" Model template in Excel (1 replies)
  167. Compiling Multiple XML Workbooks (5 replies)
  168. Test for Parenthesis at end of string (8 replies)
  169. Solved: If range has values then..... (20 replies)
  170. Solved: Shift rows to columns by condition (2 replies)
  171. Treat Several Columns as one in Pivot Report (3 replies)
  172. Extract Application information (2 replies)
  173. Solved: Value Matching Validation (5 replies)
  174. Solved: Userform writing to worksheet (20 replies)
  175. ListView .finditem syntax (0 replies)
  176. Formula and Insert the Column problem (1 replies)
  177. Solved: How to draw following plot is excel? (5 replies)
  178. Solved: split cell based on a multiple delimiters list (4 replies)
  179. Need Help: Updating dates monthly (7 replies)
  180. Transfer zip code to another column (11 replies)
  181. Solved: How to find broken links (3 replies)
  182. Solved: VBA: Find next empty cell in a certain range (4 replies)
  183. Solved: VBA: Extract Number from Cell (5 replies)
  184. Solved: VBA : multidimensional arrays to fill from a worksheet (5 replies)
  185. average over several columns/spreadsheets (2 replies)
  186. Solved: VBA create hyperlink (3 replies)
  187. Solved: Change value of one cell based on another cell (Tree logic) (17 replies)
  188. Adding Criteria to UDF functions (7 replies)
  189. IF Statement on Cell Format (2 replies)
  190. default text in (8 replies)
  191. UserInterfaceOnly problem (1 replies)
  192. Solved: Copy images with VBA (3 replies)
  193. AutoCAD referencefiles? (0 replies)
  194. VBA Splitting the text 1-8 to (1,2,3,4,5,6,7,8) (4 replies)
  195. Solved: listbox little bug (16 replies)
  196. Loading Reference aborts Sub (2 replies)
  197. Solved: extract a column to 5 column (4 replies)
  198. exporting excel charts to Word (4 replies)
  199. Solved: Make NewWebQuery with URL-variable. (3 replies)
  200. Funtions: For non-english Excel users (4 replies)
  201. Help W/UserForm (5 replies)
  202. Copy Workbook, Saveas NewFile, Edit NewFile (5 replies)
  203. Check Box Click() (15 replies)
  204. Help with Function (4 replies)
  205. Help W/Small Code . . (3 replies)
  206. Saving a screen capture ~ PrintScreen (Excel '97) (3 replies)
  207. Solved: XLD - Chart Help (2 replies)
  208. Sub reference as Cell (7 replies)
  209. Autofilling a formulae to lastrow (4 replies)
  210. Open and refresh (4 replies)
  211. Solved: Limit Entries (2 replies)
  212. Solved: Performing a task in vba if time is between 2 times? (2 replies)
  213. Solved: Disable Cmd Button (2 replies)
  214. Solved: Find String and Merge Cells (9 replies)
  215. Solved: data validation question (2 replies)
  216. Solved: Cmd Button Caption (4 replies)
  217. Solved: ComboBox won't respond to repeat of previous selection (14 replies)
  218. Solved: Button to insert row in multiple worksheets and update (10 replies)
  219. VBA help - Vlookup (2 replies)
  220. Solved: Listbox with data from other sheet problem (7 replies)
  221. Solved: VBA strangeness, need help please (8 replies)
  222. Solved: Big Automation Question with Pivot Tables and Graphs (10 replies)
  223. help with: suming only colour filled cells in a column (2 replies)
  224. Solved: Email through Outlook contacts (11 replies)
  225. Solved: file name extensions (4 replies)
  226. Solved: Counting number of pages in word (2 replies)
  227. Solved: macro for every cell on the sheet (5 replies)
  228. Solved: Create a rolling reference number (2 replies)
  229. Transfer items from list to textbox (6 replies)
  230. Solved: Worksheets name (1 replies)
  231. Ignore Hidden Sheets in vlookup macro (1 replies)
  232. chasing ranges that move (6 replies)
  233. Solved: Row to hide on drop down selection (7 replies)
  234. Complex workbook_open solution needed (0 replies)
  235. macro to delete files - three days later (3 replies)
  236. How to retrieve DataSource of chart (1 replies)
  237. X-Y scatter graph refering a series of data log (7 replies)
  238. Macros in personal.xls execution based on different file names (7 replies)
  239. Solved: Inrease a number in a column basd on condition (4 replies)
  240. Solved: Display items of a collection in a message box? (2 replies)
  241. need a code..... (25 replies)
  242. "yyyymmdd_hhmm" change to Date, Time format (9 replies)
  243. Option Buttons (7 replies)
  244. VLOOKUP MACRO NOT WORKING PROPERLY (0 replies)
  245. Solved: SOme one help find out what is happening (0 replies)
  246. referencing of cells shows formula not values (3 replies)
  247. Solved: Help using For loop in a IF then statement (3 replies)
  248. Need Help W/Sort (5 replies)
  249. Solved: Create History (5 replies)
  250. Workbook_Open Does Not Work (2 replies)