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

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