PDA

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. 'For' loop
  2. Solved: Count number of cells and export to Word
  3. Solved: Validate Input Data in Userform
  4. Solved: Save current workbook to filename in format dd.mm.yy+string variable
  5. Loop through listView & update checkbox
  6. Opening A Sheet From A Combobox
  7. UDF to calculate moving average
  8. Sleeper: Can't shut down excel.exe process
  9. Convert sql to vba code
  10. Solved: Several issues with my code
  11. [SOLVED:] VBA Email - Reply to Address
  12. Advance Filter
  13. Solved: Dynamic List of Worksheet Names based on criteria
  14. Solved: Copy & Paste and Adjust Data
  15. Copy & Paste data from column I
  16. Want to convert a Date
  17. Switch to an Active web browser windows with specific title
  18. Categorize Deadlines Based On Past Due/Period Remaining
  19. Comparing lists in columns?
  20. Solved: Userform query
  21. Solved: Colour entire row
  22. Solved: Timing my macro
  23. EXCEL CHARTS
  24. Solved: subtract date/time formatted fields
  25. Accessing Addin functions with VBA
  26. Calculating installments left
  27. Can't get PasteSpecial to work
  28. Solved: fill blank/black cells with 0
  29. Solved: Copy more than one sheet to new workbook
  30. Calculating project time
  31. Run Command When Push Print Button?
  32. Solved: Getting Rid of an Annoying Feature in Excel
  33. Getting date format in comboboxes?
  34. Solved: VLOOKUP Help
  35. Time and column spacing
  36. [SOLVED:] Want to halp USEFORM
  37. How to change mixed case names to proper case?
  38. Solved: Force Hide Formula Bar
  39. Validating values of a column in a file from another file
  40. Solved: Script out of Range on Variant Array
  41. Solved: Problem when trying to use close method of workbook object
  42. Sum not correct
  43. Modify a macro
  44. Solved: Dynamical generate name ranges
  45. Find and replace (Excel&Word)
  46. Logging into website
  47. Solved: Amend Macro in worksheet Cashflow Yearly
  48. Solved: SearchWord Help
  49. Solved: VLOOKUP AND COLUMN FUNCTION
  50. Solved: Alternative to "vlookup" function
  51. [SOLVED:] Tricky copy and paste macro
  52. Solved: Automatically Update graph
  53. ploting the graph according to the sheet selected
  54. ploting the graph according to the sheet selected
  55. Rowheight plus a little bit more
  56. [SOLVED:] Delete Rows that contain X in column Y?
  57. Modifying the existing graph
  58. [SOLVED:] Beep in Excel
  59. How to select changing cells within a column
  60. [SOLVED:] How to paste X in column A according to the length of column B
  61. Amend Forumla
  62. [SOLVED:] Return a Range in a function
  63. Debug Help with a Delete button
  64. Viewing records in workbook\worksheet form
  65. Email/Excel/based on a condition
  66. [SOLVED:] Ranges as arguments in a VBA function called from the formula bar
  67. [SOLVED:] Between dates in vba
  68. [SOLVED:] Dcount Last Character In Column
  69. Solved: List all files in folders
  70. [SOLVED:] Summing Macro
  71. Solved: Add To Code
  72. Solved: ListView control with images
  73. Data shifts on adding new customers
  74. FONT COLOUR DROP DOWN ON CELL
  75. A program to delete certain cells
  76. Solved: IF THEN COMMANDS??
  77. Solved: Vb New Line
  78. Chnage formula to ONLY allow column D and K
  79. Email Run-time error predicament
  80. Problems with Saving permissions
  81. Networkdays Formula
  82. Solved: Find cell and return value as string
  83. VBA Cell value mutiplication
  84. Solved: Need help with Loop routine to enable 20+ checkboxes
  85. Solved: excel2000 question
  86. Solved: Save As an Excel using VB
  87. Count non-hidden cells in a pivot table
  88. setting a workbook as a constant
  89. Hide value in Listbox if 2nd Column = 0
  90. Solved: 2 dimensional dictionary object
  91. excel spreadsheet to .EXE
  92. Solved: sum values based upon 2 conditions
  93. SUM/COUNT CELLS BY FILL COLOUR
  94. Solved: Very Custom Program
  95. Processing XSD schemas using VBA
  96. Double Entries
  97. Solved: Populate Listbox with Mulitple Columns
  98. Copy data from web
  99. Solved: Leave TextBoxes Blank
  100. Solved: Hide Row Based On First Few Letters
  101. Solved: Change PivotTable Data Field in VBA
  102. Solved: It's late, please help simplify this formula
  103. Error's want to help
  104. Copy variable range and copy to another sheet
  105. Solved: Save as Filename with a variable text
  106. Set SummaryRow format
  107. Combine2 Name Colums to Create emails
  108. [SOLVED:] Help with Replace Function
  109. Edit a cell depending on previous choice.
  110. Solved: Available Resources issue
  111. Solved: Vlookup from data in unopened file?
  112. Solved: variable not defined in
  113. How to enter date into pop up, which enters into spreadsheet
  114. How to compare the difference between 2 excel files
  115. [SLEEPER:] Create request
  116. Last Duplicate Value in Column
  117. VB code
  118. Solved: Followhyperlink code
  119. Solved: Custom Formats
  120. Copy data from Multiple to SINGLE worksheet.
  121. Pivot Page fields to new sheets
  122. greatest date and time
  123. Solved: adding locked cells via macro
  124. Solved: Copy range from one sheet to another
  125. Solved: Copy row of sheet2 (if data does not match sheet1).
  126. Advancedfilter Delete Row(s)
  127. IF STATEMENT TO extract result
  128. [SOLVED:] Alter Code To Allow Spread Sheet To Close
  129. Insert today's date, save file and close
  130. Excel Signing Invalid because of XLA location change
  131. [SOLVED:] Insert column
  132. How to delete all rows that don't have a specific name - e.g. "XYZ"
  133. Number format Question?
  134. Run macro automatically when a cell value changes
  135. Select check box on web page
  136. highlight cells between two dates in cluding the cells with the dates
  137. Font color
  138. Help using Excel as a database
  139. How to give a dataset corresponding ranges?
  140. Print when Command button is pushed
  141. [SOLVED:] Message Box Input calls Tab Name
  142. [SOLVED:] Loop for Value True/ Copy 4 cells to other sheet
  143. VBA Question - How to find the contents of one cell in another worksheet?
  144. Solved: Macro Problem - Hanging
  145. Solved: copy sheet and change formula reference
  146. Solved: Removing numbers from a text block
  147. Sleeper: Linking worksheet together
  148. Formula Error
  149. Code to allow A Customers ID to only go in a spread up to 3 times?
  150. Place in first empty textbox?????????
  151. Placing in the same row as a spefic customer
  152. UDT Question
  153. Solved: Save button
  154. Solved: How can i?? Press a button and it will make a calculation of +30days!
  155. Solved: What can i do when it says not a legal object name.. and then wont let me do anythin?
  156. Solved: Save button
  157. When using a combo bow to select a row
  158. Solved: find duplicate entries in colunms
  159. Solved: Edit code to change cell value
  160. Solved: Loop through sheets
  161. Solved: Restrict Menus & Right Click Menus & short keys
  162. Solved: How can I create linked Vlookup data from multiple closed workbooks
  163. Find and Replace Page Down in excel
  164. Multiple Charts To Multiple Slides
  165. conditional adding through sheets in a loop. Novice.
  166. Solved: Jump to last worksheet
  167. Runtime error in macro
  168. Solved: Save in both Excel 2003 and 2007
  169. Solved: Remove ' from text
  170. Simplify Code
  171. Duplicate Master freeware utility?
  172. Custom Sort
  173. Sort, Page Break and Page Header according to cell values in different worksheet
  174. Solved: Passing variables through properties
  175. Sub or Function for IF ...
  176. Split text between cells Help Needed
  177. collection issue with custom type variable
  178. [SOLVED:] Move sheets to new book (array)
  179. Copy and paste data after printing
  180. Solved: Partial String ListBox search to populate another ListBox
  181. New Excel Application
  182. Solved: Green if zero, Red if not
  183. Subtotals using Macro ...
  184. Notification when macro is executed
  185. Solved: Notification when macro is executed
  186. [SOLVED:] How do you return / pass values?
  187. When looping through sheets remove subtotals only works on first
  188. Solved: Combining macros
  189. Using a combo box to select a named worksheet
  190. Command Button to save, print and clear
  191. How to delete a row if it contains a word?
  192. Solved: Code change to allow for Data table changes
  193. Solved: Loop through one column on any sheet in workbook....
  194. CommendBox
  195. Solved: Feeling dumb today!!!
  196. Getting Data from an Excel Spreadsheet object to a normal excel spreadsheet
  197. [SOLVED:] Add Border if Statement
  198. Count coloured cells and display result in table.
  199. Group 2 cells like in a userform.
  200. Excel Right Click Menu Always Up
  201. rectangle question
  202. Solved: Saving As Text adds double quotes to some lines!
  203. VBA for time display
  204. Check if a file on the web exists
  205. Controlling Internet Explorer's "Print pop-up"
  206. [SOLVED:] Clipboard is full
  207. Solved: move up
  208. Random number generation
  209. Summing a column based on two criteria in other columns
  210. Listview help
  211. Pass a named range into function issue
  212. How to find the last duplicate value
  213. Solved: Problem auto-installing VBA add-in
  214. Formatting entire row based on text in first column
  215. Combobox Visibility After Drop List Selection
  216. Help! I'm working with two spread sheets
  217. [Help Please]Parsing parameters to event
  218. If no dependents msgbox and resume loop
  219. C&P all data of all the sheets/workbooks in a folder.
  220. Execel, OLEObjects (buttons) sometimes not firing, triggering
  221. Excel Macro Help Please
  222. problem using a function from an external library in vba
  223. [SOLVED:] Variable Columns Lengths
  224. Solved: Create a worksheet for each value in Column A
  225. Split string into multiple parts no bigger than 240 chars?
  226. Solved: alpha-numeric 2
  227. Solved: case yes-no, can the code be smaler?
  228. [SOLVED:] Easy! How to make a button that generates a random number?
  229. Solved: using a worksheet function in vba
  230. Solved: Sum and compile list of entries
  231. Solved: any value in a range = 0 then return 0 ?
  232. Solved: From one array to another
  233. Solved: problems saveing two copies.
  234. Solved: Userform buttons to enter numbers into textbox
  235. Solved: problem of structure
  236. copy range, skip empty cells
  237. Solved: Fast Compare using Filter
  238. Alternative to Eomonth formulae question
  239. Solved: make a dynamic if statment?
  240. [SOLVED:] Special Transpose
  241. From one sheet to another...
  242. loop + offset/resize problem
  243. Extracting certain data to another sheet
  244. Macro Security
  245. worksheet is not picked up in Vba
  246. Solved: Stop Them Deleting Rows
  247. Solved: Hours to be worked by Month
  248. Date Format
  249. MACRO/VBA help!!! :S new line... etc
  250. Getting around Pivot Table 256 Col Limitation