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