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