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: Horizontal Sorting (6 replies)
  2. Working with Cell Comments (0 replies)
  3. Transparent Command Button Covers Text (0 replies)
  4. Solved: Compare Column Data (3 replies)
  5. Solved: Creating a number of workbooks (17 replies)
  6. Copying a row in Excel using VBA (6 replies)
  7. Get entire worksheet range (3 replies)
  8. Add 1250 textboxes in excel using vba vb6 (4 replies)
  9. random (4 replies)
  10. [SOLVED:] Sending Excel range to Access; question... (3 replies)
  11. Unviewable projects (9 replies)
  12. how to stop at the last row (13 replies)
  13. Formula help (2 replies)
  14. Greate ChartLines & Show SeriesPoint(i)Values? (0 replies)
  15. Create New tab (6 replies)
  16. Save file as TXT or CSV (2 replies)
  17. Listen to double click (3 replies)
  18. How to highlight conditional formatting (4 replies)
  19. Solved: Defining a variable number of arrays? (2 replies)
  20. Solved: copying value set to variable (5 replies)
  21. using vba to copy and paste from a website (5 replies)
  22. vblf's peculiarities (3 replies)
  23. Solved: Total distance and time between two cities in a state (50 replies)
  24. add item to a listbox (1 replies)
  25. Solved: is there any way i can change the WB created date (2 replies)
  26. [SOLVED:] Saving a chart to .pdf (8 replies)
  27. Solved: Copy 2 cells with formula. (9 replies)
  28. Changing dates in a cell (1 replies)
  29. DTPicker (2 replies)
  30. Wierd Calculation Issue - VBA- Excel (2007) (3 replies)
  31. Solved: Separating between each two digits (6 replies)
  32. Force enabling macro (1 replies)
  33. mail item problem (3 replies)
  34. Install a new font in Excel (2 replies)
  35. Solved: Deleting Defined Names (6 replies)
  36. Assort information in columns from rows (9 replies)
  37. VBA OOp (2 replies)
  38. Need help replacing For Next Loop with AutoFilter (1 replies)
  39. Classes (12 replies)
  40. Find row based on picture (2 replies)
  41. Update links between workbooks (0 replies)
  42. Run time error '6' (9 replies)
  43. Problem with UDF Function (3 replies)
  44. Solved: represent column by variable (2 replies)
  45. Control on Combobox (2 replies)
  46. Solved: extend the border line until desired row (2 replies)
  47. Solved: Error Setting Selection.Formula in a ListColumn (2 replies)
  48. hyperlink (2 replies)
  49. Defining an array as a range of cells (4 replies)
  50. Solved: Deleting duplicate data (3 replies)
  51. How to delete external links excel 2007 (3 replies)
  52. [SOLVED:] Macro to find specified date in a range (4 replies)
  53. Solved: SEARCH COLUMN FOR VALUE AND COPY ROW (10 replies)
  54. Finding the min or max value in a sub range of a reference. (1 replies)
  55. Random Sampler Macro (3 replies)
  56. align input data (3 replies)
  57. Solved: find first item in column (10 replies)
  58. Copy specific multiple groups of sheets to new workbooks (1 replies)
  59. Pivot Table (0 replies)
  60. transpose macro (5 replies)
  61. Solved: Run-time Error 70 creating application object in Windows 7 (2 replies)
  62. Range References in VBA when Wks Rows/Columns Deleted (1 replies)
  63. Solved: Sum an array of data when records are > $xxx (3 replies)
  64. Solved: Write to Word from Excel (2 replies)
  65. How to import XML to excel without the HTML, I think? (0 replies)
  66. Solved: converting multi-dimension array to single-dimension (1 replies)
  67. Solved: Unmerge target cell (2 replies)
  68. Worksheet event code to copy Formula (0 replies)
  69. Adding a blank string in between (1 replies)
  70. how do we access a variable declared in one form to another form (8 replies)
  71. Printing specific records (5 replies)
  72. VBA help: need to transfer 130 cells to memory and back (1 replies)
  73. Find and Replace Dynamic values (2 replies)
  74. Dynamically creating variables...possible? (1 replies)
  75. Charting Scenarios (0 replies)
  76. combobox generate another combobox (5 replies)
  77. How to compare two same files (0 replies)
  78. Bookmark Runtime Errors, 5941 and 462 (1 replies)
  79. Solved: vba vlookup fix (6 replies)
  80. Solved: Changing default weekday (4 replies)
  81. combobox generate another combobox (1 replies)
  82. Exchange (part of) file name with a cell ref in Vlookup formula? (11 replies)
  83. Copy row to the duplicate row - Macro (7 replies)
  84. Solved: Putting a slash between numbers and text (13 replies)
  85. Solved: Count an array of data based on Sum (17 replies)
  86. Solved: VLOOKUP Question (2 replies)
  87. Solved: auto run the macro (2 replies)
  88. Solved: SUM(IF with an OR statement produces incorrect results. (2 replies)
  89. Open and copy/paste data to same row... (7 replies)
  90. Solved: 1004 error (4 replies)
  91. Sum of Cells Within the Selected Range (vba) (3 replies)
  92. Copy contents from various excel files in a folder and merge (0 replies)
  93. Create school timetable by vba (19 replies)
  94. coloring similar cells in values in the same column (12 replies)
  95. con.open error message data source name not found no default driver specified (1 replies)
  96. Capturing UNDO Stack (3 replies)
  97. Confused About Run-time error '1004': Application-defined or object-defined error (7 replies)
  98. Problem: ClassFactory cannot supply requested class (7 replies)
  99. Solved: Avoiding errors in formulas (2 replies)
  100. ِAccepting new repeated entries or not (3 replies)
  101. Set trial period for use of your project (0 replies)
  102. Month selection (2 replies)
  103. Tool or editor require for understanding return value of each argument of so many nes (6 replies)
  104. [SOLVED:] Uncheck CheckBoxes if one is checked (7 replies)
  105. Solved: Worksheet Change Event (13 replies)
  106. Copy & Paste Dates with Macro (4 replies)
  107. Solved: index/match (12 replies)
  108. User form will not allow blank fields (4 replies)
  109. Need macro to list folder with name and size in excel. Thanks (6 replies)
  110. Solved: Events (5 replies)
  111. lookup function in VBA (6 replies)
  112. VBA Code to know the date of creating a new worksheet (4 replies)
  113. how to change multiple value instead of one value at a time? (6 replies)
  114. Solved: Filter from Drop Down Box (3 replies)
  115. Solved: Hlookup and Vlookup problem (2 replies)
  116. Stop dialog box popping up (6 replies)
  117. Combo Box / List box help (1 replies)
  118. Solved: could not set the value property. Invalid property value (2 replies)
  119. Excel 2007 macro for comparing multiple dates (3 replies)
  120. Solved: Use Vlookup in VBA Code (4 replies)
  121. Solved: VLOOKUP the Nth Occurance (3 replies)
  122. Grabbing Data..Excel VBA (3 replies)
  123. Is this a timeout issue? (0 replies)
  124. [SOLVED:] Extract a string from a cell (8 replies)
  125. Solved: How to create Yes or No Message Box? (6 replies)
  126. Solved: using name in VBA propertys vs Sheet name (4 replies)
  127. Solved: Selecting a Range of Rows (9 replies)
  128. Search Function in a User Form (2 replies)
  129. Executing Macro at Time with Excel Closed (0 replies)
  130. Solved: Date as an Index (8 replies)
  131. Solved: Removing certain string (2 replies)
  132. Solved: Detecting Conditional Formatting (3 replies)
  133. Solved: Football Team Record Ranking (10 replies)
  134. Help with Syntax Using ADO to Query Excel Worksheet (4 replies)
  135. Solved: Error Handling (2 replies)
  136. Solved: Add 1 when copying and linking. (3 replies)
  137. Multi Select List Box based on Advanced Filter (0 replies)
  138. Solved: Change cell colour if changes made (2 replies)
  139. Divide the Column Data using VBA (11 replies)
  140. vba MultiSelect ListBox based on advanced filter (0 replies)
  141. [SLEEPER:] Use combobox as history (0 replies)
  142. Solved: XY chart with values on top of each other (2 replies)
  143. [SOLVED:] How do you clear filter in macro? (2 replies)
  144. Split The Column Data based on first column values using VBA (1 replies)
  145. adding up interchanging word in a single cell (1 replies)
  146. Sorting While in .FilterMode (0 replies)
  147. VBA Code Problems with Sending Excel DB through Outlook (2 replies)
  148. Solved: How to export bookmarks from word to excel (13 replies)
  149. Solved: Formula to allocate absolute values (9 replies)
  150. Set StartCell as ActiveCell (10 replies)
  151. Solved: Hide unhide rows in range (23 replies)
  152. Use of Ajax in an inputbox? (4 replies)
  153. Solved: Why is this code simply exiting without reason? (6 replies)
  154. Write a value from a cell formula (1 replies)
  155. Solved: Excel VBA (19 replies)
  156. Solved: Delimiting in odd situations... (2 replies)
  157. Solved: Probably a quick solution to this! - finding rows (8 replies)
  158. Extract a list of employees according to month (5 replies)
  159. VBA for multiple excel file (0 replies)
  160. Solved: multiple file selection (5 replies)
  161. Solved: Clear cell contents without deleting formula (4 replies)
  162. Selection (4 replies)
  163. Excel Macro Help (2 replies)
  164. Solved: Using a Date variable in Excel 2007 macro (3 replies)
  165. Can this code be simplified (2 replies)
  166. Solved: Macro Recorder Code fails (12 replies)
  167. Excel to Word... little help required (4 replies)
  168. VBA to copy 3 worksheets and email (0 replies)
  169. VBA Error help please (3 replies)
  170. Conditional locking of row (13 replies)
  171. Playing with arrays... sort of (13 replies)
  172. Formulas (6 replies)
  173. Solved: Intersect (10 replies)
  174. Excel 2007 Macro Recorded (3 replies)
  175. Download from Excel via URLDownloadToFile (4 replies)
  176. Solved: Listening to the active sheet's events from the personal macro (2 replies)
  177. Delete named Sheets if they exist (4 replies)
  178. Solved: how does xlMultiply work? and can i paste and multipy in one go? (4 replies)
  179. Sum months plus today (1 replies)
  180. Help With automatically reading a column (2 replies)
  181. Solved: Reading a .csv File? (4 replies)
  182. Solved: ActiveCell.FormulaR1C1 dynamic column (2 replies)
  183. Solved: Userform & Class Module Interaction (4 replies)
  184. Solved: xlCellType (6 replies)
  185. Solved: finding MAX number and matching symbol (3 replies)
  186. Problems with foreach loop in a modul (2 replies)
  187. translating math formula into vba (19 replies)
  188. [SOLVED:] Aligning data labels in a chart (8 replies)
  189. [SOLVED:] Working with a text file (5 replies)
  190. Solved: how to paste only value since there r some fuction in cells (2 replies)
  191. Solved: inserting date where cursor located (9 replies)
  192. Solved: Calling a Function and Resize (2 replies)
  193. Question on insert Object (1 replies)
  194. Return Row info based on Column dates (12 replies)
  195. Solved: load a one dimensional array from non-contiguo (2 replies)
  196. Sleeper: Can I run an executable within my VBA? (1 replies)
  197. Solved: Count Business Days Between 2 Dates (7 replies)
  198. Solved: Alignment on coding page (3 replies)
  199. Solved: Find,MatchCase PROBLEM (2 replies)
  200. Way to get innertext of all childnodes of a node? (0 replies)
  201. Color Banding Rows (2 replies)
  202. Using Custom Views (0 replies)
  203. Solved: Formula help (32 replies)
  204. Assigning a cell to a row that has a cell with a similar value (1 replies)
  205. Solved: Date picker 2003 (2 replies)
  206. Solved: If else doesn't work the way I expected (2 replies)
  207. Save Excel Userform as a Web Page (0 replies)
  208. Dynamic Formula put in formula with VBA (3 replies)
  209. Excel 2007-UPDATE Links ISSUE with excel 2003 file (0 replies)
  210. Changing AutoFilter Range (7 replies)
  211. Is it possible to ask vba to write html code in to an html file? (18 replies)
  212. Creating sub-blocks within a large data-block (5 replies)
  213. delete duplicate text (1 replies)
  214. Multiselection areas: how to manage? (3 replies)
  215. Solved: Scroll worksheet when userform is present (2 replies)
  216. Need help on VBA coding.... (5 replies)
  217. picking range from "A1" to variable (1 replies)
  218. Userform Activate not firing in Excel 97 (5 replies)
  219. Pick a Workbook and mail its worksheets (4 replies)
  220. Solved: Error on Insert Picture code... (10 replies)
  221. Solved: On open excel (9 replies)
  222. How to Modify Userform? (4 replies)
  223. Macro to return picture in a cell? (1 replies)
  224. Remove duplication and fill a form (0 replies)
  225. Using arrays in vba excell (1 replies)
  226. Solved: Calling a Function, of Sorts (14 replies)
  227. Extract Data to Excel from a Website. (2 replies)
  228. Solved: label caption (2 replies)
  229. Loop but Subscript out of Range (8 replies)
  230. Solved: Copying comments from one workbook to another (2 replies)
  231. Pivot Table Show All (4 replies)
  232. Solved: Save chart as image plus refresh (3 replies)
  233. VBA code to open an Excel workbook readonly (5 replies)
  234. Formating lines in table/pivot table (3 replies)
  235. Average of n elements in an array (5 replies)
  236. Pulling data according to a cell value (1 replies)
  237. Not sure what to do. (4 replies)
  238. copy cells from excel table into a pre-formatted table in word (2 replies)
  239. Solved: copy the formula or address (2 replies)
  240. Auto Import Text file GetOpenFilename no dialog (1 replies)
  241. Userform Search help! (4 replies)
  242. Display label results in a texbox (6 replies)
  243. manage datas from a multilection rows (5 replies)
  244. gif animated picture on a user form !!! (2 replies)
  245. Solved: Removing Noncontiguous DropDown Arrows (2 replies)
  246. Solved: Dir Function - Sequential files (3 replies)
  247. Solved: Compare two sheets semi-manually (0 replies)
  248. Solved: Escape from Edit Mode (2 replies)
  249. Solved: Help Identifying Empty Cells (2 replies)
  250. Solved: Copy Paste non-adjacent cells in a range (2 replies)