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

  1. Solved: UserForm event 2
  2. Macros in Excel
  3. Find column (in Excel address) of matching value in array
  4. Copy Images within Selected Cells
  5. Solved: Before Close
  6. Solved: Keep the only Sheet
  7. Security Level change
  8. problem with running event-based macro
  9. Retain Contents of Clipboard
  10. Missing Sequential Number In Station Column
  11. Pivot - Removing Calculated Field
  12. Solved: delete from nth character
  13. Function to count values but not formulae
  14. Edit cells from listbox with userform
  15. Solved: Return a value into a textbox when selecting a worksheet name from a combobox
  16. Help to update data repeatedly by VBA
  17. Solved: Loop through two worksheets
  18. Solved: countif function
  19. Concatenate VBA that Keeps Applied Formatting
  20. Solved: Selecting an Empty Row and range naming the selected cells
  21. Solved: Formatting a Multi-Conditional If,Then Statement
  22. Solved: Worksheet Problem
  23. SendInput() in Excel 64Bit
  24. Accessing records in Recorset
  25. Solved: Syntax error: please help
  26. Changing cell references to activecell reference
  27. Search UserForm
  28. Similar change, multiple worksheets
  29. Solved: Dynamic Pivot Table contents
  30. Select the first two similar values
  31. Importing .html file into Sheet in Excel in VBA
  32. Solved: Can this code be shorten vba
  33. Shape Fill by Clipboard
  34. Need Excel VBA Help
  35. Solved: help on workbook connection vba
  36. Exporting worksheet and overwriting
  37. Compiling data
  38. Solved: returning cursor to incomplete textbox within userform
  39. Problem finding ranges without using Selection
  40. Solved: autocomplete in a cell
  41. UserForm_QueryClose vs Unload Me
  42. Unprotect then protect after Workbook is opened
  43. Distinguish between two similar values
  44. Using conditional FormatConditions Method
  45. Open another workbook and search for cusips
  46. VBA reading multiline textbox line by line
  47. Creating Links
  48. Linking Sheets
  49. Duplicating macros across worksheets
  50. If two geographical data match in two sheets, then add/copy/replicate unique id/code
  51. Solved: Selection code is not accepted
  52. a named range with more than seperated range
  53. Searching for items in another excel sheet
  54. Elimination of things in a cell
  55. Excel VBA/Macro - Search against Multiple Criteria
  56. Solved: on open show combobox with 10 choices
  57. Solved: Add Caption problem
  58. Solved: Activate the Add-In Screen with VBA
  59. Solved: Application.Visible = False
  60. Scrollbar for list of Labels
  61. Filling cells with a formula
  62. text display
  63. File name in cell
  64. selcting then hiding
  65. Solved: Who opened my workbook?
  66. Trying to get a False result from DTPicker
  67. How can I speed up my RemoveAt procedure?
  68. To identify the duplicate rows and copy the unique rows alone from sheet1 to sheet2
  69. Solved: How to fix a formula value without vba
  70. Sheets
  71. Remove words
  72. call a sub from another sub
  73. Simple way to know Control Panel status
  74. Solved: Errors with date functions
  75. multiple text file import in single excel sheet
  76. check if a value is in a recordset
  77. Hide Macro code
  78. how to add my company logo as footer on every sheet vba.
  79. Can't find project or library
  80. Active Directory Query with Macro
  81. VBA CODE FOR PIVOT TABLE
  82. Select the MIN value in a data range
  83. VBA Excel 2007
  84. Pivot Table Autoformat XL2003
  85. Check if cells is empty
  86. Solved: VBA to exclude Public Holidays
  87. Password protected Workbook
  88. Solved: Select Cooresponding Cell Fron Listbox
  89. Duplicate values
  90. Delete empty rows
  91. Solved: Disable "save changes" pop up when closing
  92. Solved: ComboBox (SOLVED)
  93. locking cells without sheet protection
  94. Solved: loop in a loop
  95. Applying formulas to certain cells
  96. Need help altering Planner VBA
  97. Solved: Deleting rows based on column content.
  98. Solved: refer to value in a cell in a macro
  99. veiw variable/ array values during debug
  100. macro to find and replace #ref errors with actual cell values, and stop at last sheet
  101. Runtime error 1004
  102. How to add formula and value to cell VBA
  103. Help to generate week ending from days as per financial new
  104. Solved: Excel VBA comparison wierdness / challenge
  105. Solved: Vba debugging Run-time error '1044':
  106. VBA: selecting data to be outputted to new sheet
  107. Solved: removing part of string
  108. Select OLEobject checkbox PROGRAMMATICALLY???
  109. Drop down boxes and forms
  110. Cell references
  111. Problem with Interactive Graph with Rollover Hyperlinks and UDFs
  112. referencing information between userforms
  113. Making a workbook visible again
  114. Problem with my search/replace macro
  115. Error in expression
  116. Moving rows from one spreadsheet to another
  117. Solved: Filling a formula
  118. VBA: Selecting and Copying Columns [more complex than it sounds]
  119. Solved: Can these 2 VBA codes be merged in to 1
  120. Solved: If Or Statements with VLookup
  121. Solved: Dates as X-Axis for multi-series line or xy chart
  122. Solved: Select defined range
  123. Solved: Data Validation Macro Problem
  124. Solved: Need help to change column to comma style
  125. Solved: copy data fom 1 workbook to another, where itneeds to go to 2 different worksheets
  126. Solved: Finding and highlighting duplicate names
  127. VLOOKUP - works on 1 form but not on another
  128. Solved: vba help to automate report.
  129. VLOOKUP error codes in VB
  130. VBA: Selecting Sheet via Input Box or other way
  131. Solved: commandbutton that "follows" cursor
  132. Solved: Search Range of numbers and return missing
  133. Copying Multiple worksheets in Multiple workbooks to one single workbook
  134. Solved: Application display alert question
  135. Solved: VLOOKUP
  136. Solved: Colour Cells
  137. Best use of memory
  138. Solved: Footer Capation
  139. Solved: Drive Letter
  140. Solved: Can these 2 VBA's be combined
  141. Extracting Model Numbers
  142. Solved: Onaction property
  143. Solved: Select End Row
  144. Solved: Paint next three columns
  145. VBA script doesn't run
  146. Check port is up from VBA (Excel)
  147. Adding header data during data extraction
  148. Combo/List Box populated by user form entries
  149. Solved: Filling a formula
  150. When file is open Automatically run VBA
  151. Help Understanding Code Dealing with Creating New Spreadsheets
  152. Solved: Inserting cells in between entries
  153. Tabs to different work books.
  154. If there is no chart on activesheet, then go to NoChart.
  155. Hide CMD window that script shows.
  156. Solved: Tweeking formula
  157. Solved: Moving row to another space
  158. Solved: Cells with zero or no value - amend
  159. Limiting array size
  160. Solved: Bold last row of spreadsheet
  161. Solved: Apply formula to all cells in a column
  162. Solved: Mark as XXXXX
  163. Copying data from one sheet to a specific range of cells in a different workbook
  164. Copy data from first workbook to a different workbook based on cell value in first
  165. Manipulating recordset
  166. conversion of VBA to vb.net
  167. Simple Supply and Demand Model using Solver
  168. SEPARATE ROWS WHEN CONDITIONS MET
  169. Solved: Apply code to second to last line of spreadsheet
  170. Solved: Can't manage to rename updated version
  171. Solved: Range("e1").Row = 5 not e
  172. Solved: Placing text in a next empty Cell with VBA
  173. Ask: Pull data from another sheet with macro (excel 2003)
  174. Solved: Counting account numbers
  175. Create sheets from master but copy them to new book
  176. problem:filter pivotable with 2 text cells
  177. Solved: Word to excel & 'clip'
  178. Solved: Dealing with dates in macros
  179. Solved: Moving rows from one sheet to another using vlookup
  180. Unable to set the XValues property of the Series class
  181. Solved: Copy and pasting selection of data
  182. Solved: Accessing The Reference Cell Contained In The Excel VLookUp() Function From VBA !!
  183. Locking the name of a range
  184. Getting a total copied set of rows in VBA and storing it in a variable
  185. Solved: Copy and past in next available row
  186. Create a date entry for each day of the month
  187. Update everyday at 2:30
  188. Solved: Activating sub from another workbook
  189. Search and copy data (Macro)
  190. Multithreading Excel and Word
  191. Solved: Hidding button on worksheet depending on password
  192. how to close a workbook on network when its open by another user.
  193. Searching an array using two criterias
  194. Excel sending emails from a worksheet
  195. Event macro for auto-fit row height of merged cells
  196. List all files in a folder or import filenames into a merged document
  197. Solved: Multiple values using SUMPRODUCT
  198. Solved: Multiple files
  199. Solved: multiple Regular expressions on one cell to extract to new cells
  200. pivot table filters problem
  201. How to display updated process on userform for user
  202. Solved: Search box on an user form
  203. Help to calculate end date for each Dept VBA
  204. auto run a macro upon text entry into cell
  205. Solved: Problem with macro
  206. DELETE ROWS BASED ON DATE RANGE
  207. Solved: Help needed
  208. Combobox linked to Listbox
  209. Solved: VBA: Values on Sheet
  210. Exceldiet deletes entire worksheet
  211. Simple way to reduce the size of the Excel file
  212. Solved: Write in Col J just Before close
  213. Prevent various functions in document
  214. Solved: Delete empty rows
  215. Data Portal Design Requires Advanced Coding
  216. Solved: Delete Menu if exists
  217. Solved: Find unique values
  218. Solved: Combining Dynamic Ranges
  219. vba form check against text file
  220. Solved: Write function in forms
  221. Solved: Can anyone confirm the destructive effect of Exceldiet in the following case?
  222. How to open speadsheet on server populate with data then save and close it
  223. Post excel cell data to Ms Publisher
  224. Solved: Extracting required information
  225. Solved: Dynamic Sum Macro
  226. compare values and paste in another woksheet
  227. Internet Form Submission
  228. Solved: button that follows by click unables copying
  229. Add an HTML file as body of email
  230. KB Article: Creating multiple word tables from excel data
  231. Run-time error 457
  232. Solved: Renaming cells
  233. Solved: Copy and pasting ONLY selected cells
  234. Event macro does not run until I leave and return to a cell
  235. Sum if function
  236. Solved: Class Member
  237. Deleting a row that has certain characteristics
  238. macro for pivot
  239. Help exporting values to text file
  240. Solved: Filtered report issues.
  241. Using if then else in excel 2007
  242. Solved: Need Macro to Replace ## with the Column Heading Name
  243. Generate Unique Reference Numbers on a userform
  244. Solved: fixing code - automaticaly handling with many of combobox, labels...
  245. Transpose help.
  246. webquery macro for website with drop down menus
  247. Forms vba excel 2007
  248. Solved: Date format problem
  249. Solved: Copying a file when the source file is open.
  250. function variables show on sheet