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

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