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