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