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