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

  1. Excel Userform - Dynamic Controls - Type Mismatch?
  2. show ComboBox at target in sharedworkbook
  3. Solved: WS Name function
  4. Solved: How to get the filter criteria automatically in AutoFilter
  5. Splitting, Sorting and Sampling
  6. Solved: Inefficiencies of Multiple Sheets
  7. Solved: Type of Chart to Use
  8. Solved: select multiple fields from different workbook?
  9. Validate startup path
  10. Solved: Insert specified number of rows
  11. Solved: Userform art?
  12. Solved: Macro to Show last seven days on Pivot Table
  13. Need Help
  14. Solved: TextBox Hit Enter Next Line
  15. Selecting 1 static cell and 1 variable cell and fill down
  16. Need Help for my CAREER!
  17. extract the data from a string of data
  18. Solved: Display Formulas -VBA
  19. Objects in Powerpoint
  20. Solved: Listbox last row Visibility
  21. Solved: separate text using delimiters
  22. Solved: Case Statement Criteria with 2 levels of assesment
  23. Solved: unptotect workbook
  24. Solved: How to eliminate part of message
  25. Solved: named ranges
  26. Solved: Excel 2003 Workbook Open Code
  27. help Modify the code
  28. Solved: Delete oldest sheet
  29. File doesnt save when i use xmlhttp
  30. Copy Rows based on Name Condition
  31. help with modifying a script!
  32. Solved: Data validation or other drop-down with different sheets?
  33. Toolbar added via VBA does not work, assign macro is grayed out
  34. Intergrate 2 userform
  35. AutoFill when new data added to sheet
  36. MMult Headache - 5 Hours Lost!!!
  37. Newbie Question
  38. Detele emply rows from the top or from the bottom ?
  39. help!!! save notepad in UTF-8 encoding
  40. macro to open up csv files from day earlier
  41. Solved: copy data between multiple sheets
  42. Workbook won't save
  43. Solved: Help
  44. Solved: COUNT IF Multiple Criteria
  45. Solved: Need to set Cell Formatting
  46. Userfrom, field formats
  47. Change cell color of Duplicates with message box
  48. Copy and Paste Error
  49. Think this should be straightforward...
  50. How to find out
  51. Copy and paste of multiple ranges
  52. locating cells
  53. find middle value
  54. Solved: Script to add rows with userform data
  55. Skip blank cells or cells with text
  56. PLEASE HELP, project due today! vba search issues, thanks!
  57. Solved: Passing a variable (and its contents) from a sub to a function
  58. opening/extracting ole object file in excel via excel VBA
  59. Solved: Autofilter problem
  60. Datafile changed by multiple users
  61. Solved: Auto Close WorkBook when Idle
  62. Problems with media player
  63. Solved: Type mismatch error
  64. Referencing Multiple Cells
  65. Automatically fill blank cells with specific text.
  66. How do i call my webservice from excel?
  67. Check if "Browse For Folder" window already open
  68. Solved: Emai Spreadsheet as a PDF
  69. Solved: Multiple non consecutive cells selection
  70. Solved: Spin Up/Down Problem
  71. Max Formula
  72. Solved: Cancel Call to Oracle Database
  73. How to count the No. of times a document is opened.
  74. Solved: controling powerpoint with excel vba
  75. Solved: What did I do wrong?
  76. Closing and opening new Excel Files using BeforeClose procedure
  77. Solved: Cycle trhough worksheets
  78. chart
  79. Countif with two conditions
  80. How to replace a particular element in a cell
  81. Date Formula (Results in last 7 days)
  82. Solved: Input Box with Drop down list
  83. kernel32 GetFileAttributes Directory type Help
  84. Solved: Add ListBox selections to specific cell range
  85. Excel data to Word Bookmark
  86. Solved: Type miss match
  87. Method of Monitoring a Workbook's Addin Collection
  88. Referring to an Userform
  89. Solved: Finding the name of a Named range
  90. Solved: Copy a range of data and paste to the last row of another workbook
  91. Solved: Wrapping text in a ControlTipText
  92. Hide userform by clicking outside form
  93. Determine media file pixel size
  94. Function to convert text into a number
  95. Failed tp activate range with listbox item select
  96. Solved: Copying a range of cell values to another existing workbook
  97. Error Handling Not Working
  98. String Variable used to define a Range object (following my previous post)
  99. count
  100. Solved: .Find method to locate >= date from message input
  101. Excel Hangs when sending multiple CDO messages
  102. Solved: Copy VBA code from ws to ws on insert...
  103. Solved: More headache w/ xl 2007 macros - HELP!
  104. Solved: string concatenation
  105. Dynamic sliders in a userform
  106. Solved: COPYING DATES FROM WORD TO EXCEL
  107. Listview ImageList VBA -?
  108. VBA to Delete cell values only
  109. Defining a range to make a Sound When a Cell is Changed to a Certain Value
  110. VBA code to select rows between values
  111. Hide Ribbon Show Only QAT
  112. Solved: ShowHideMinimize Ribbon using VBA
  113. Organizing data in a spreadsheet
  114. Solved: Get multiple cells as a result in a dropdown list
  115. Label x Axis and y Axis with VBA
  116. Solved: Blinking field in UserForm
  117. Solved: Save & Close with criteria and prevent quit excel thru X button in the right top xls
  118. Macro line for all worksheets
  119. A couple of "easy" questions
  120. Solved: Run batch file
  121. Solved: How to pass login parameters from a form to a function
  122. Solved: Text to Number
  123. Solved: Vlookup, have tried and tried, feel like an idiot.
  124. Solved: Excel Access interaction with ADO
  125. Solved: Find width of text
  126. Odd Excel behavior
  127. RegExp Add Increment to each SubMatch
  128. Userform not showing when closing previous workbook
  129. Solved: "Countif" type application
  130. Solved: VBA ranges and "for" loop
  131. Solved: Lookin multipe folder
  132. Solved: Making sheets of a shared workbook write-protected
  133. Solved: Set the cell value of another spreadsheet
  134. Solved: Conditional data validation?
  135. Solved: Insert character with VBA
  136. Solved: Linking a Macro to an IF Statement
  137. Retreive Data + Authentification via VBA
  138. Solved: Formula problem
  139. Solved: run batchfile?
  140. Excel Negative Time Format
  141. Solved: Insert column then autofilter data
  142. Search form with many option
  143. Solved: convert macro
  144. Solved: Dynamic hyperlink in a cell
  145. Solved: Cutting out the five right letters from ActiveCell
  146. Excel Formula Language Translator
  147. Adding a ribbon item...excel '07
  148. Need to execute code at specific time
  149. Solved: Stacked Column Chart with VBA
  150. Disable sort A-Z from filter excel 2007
  151. Solved: Changing Values On UserForm ListBox
  152. Solved: Quick syntax issue on find last row
  153. Solved: Resizing a DropDown Box
  154. Help for Macro to VLookup in multiple files
  155. Syntax error after compiling
  156. Populating Text Box in Userform with Label Value
  157. Deleting Blank Rows
  158. rearranging columns
  159. Solved: Toolbar/CommandButton - OnAction
  160. Any good websites with free active x controls
  161. VBA rnus slow in Office 2007
  162. pass
  163. Solved: Getting the Selected value of a combobox
  164. Solved: Copy data from one Worksheet to another based on Flag
  165. Solved: Test Multiple Variable for Same Result
  166. Don't to change name of sheets
  167. Solved: Sort Method Not Working!
  168. Solved: FileSearch Compatability with Excel 2007
  169. Perfect Gauge Chart in Excel 2007
  170. Solved: Find Copy Row and Paste
  171. Solved: Tally Domino game score
  172. cell linked with another cell
  173. Solved: Accessing form buttons from sheets
  174. Solved: Problem with Autifilter Date Range
  175. How to undo code (delete it without causing errors)
  176. VBA click questions
  177. Adding to worksheet from ComboBox Selection
  178. Solved: If Contains
  179. Checking Multiple Radio Buttons have been 'clicked'
  180. VbCode changes need review
  181. Solved: Highlighting Rows based on a Text String Search
  182. Solved: Spin button scrolling through cell links
  183. Another Excel coding riddle
  184. Solved: Selecting part of a cell's contents
  185. Solved: Excel Code running too fast
  186. Solved: Code Tweak
  187. excel dropdown
  188. Time Stamp Not working
  189. Solved: Activate next cell ?
  190. Countdown between dates
  191. Solved: Draw Arrow Length of Cell Selection
  192. How to use ADO to connect file on gmail driver
  193. Solved: Global 'Excel.Range' alternative?
  194. Inserting Rows + ScrollArea + Protection
  195. Project locked Error
  196. select all range
  197. Outputting runtime macro to footer of Excel
  198. copy specific columns from one excel file to already opened excel file
  199. Solved: Check box prompt
  200. Solved: Inserting Picture in charts thru VBA
  201. Solved: Number format issue in multicolumn listbox
  202. Stats in a variable location
  203. Solved: Form Control vs. Control Box control
  204. Solved: IF statements in excel
  205. Solved: changeing background colour of a certain cell
  206. Solved: Removing text from a field
  207. delete all charts in workbook
  208. Solved: Transferring data from one workbook to another
  209. Solved: countif
  210. Solved: Excel query from foxpro with variables
  211. Active Cell = Bolding
  212. Solved: Update Excel Query Programatically
  213. macros can't find macros in personal.xls
  214. VLookup macro and variables
  215. VBA cannot open excel sheet if another excel is open!!
  216. Update Question
  217. Importing data from visio to excel
  218. Solved: Help for Turning Off Alerts for Missing Addin
  219. color cell depending on input
  220. Extra Workbook called Sheet2 has appeared
  221. Solved: Tricky situation:-Delete readonly folder in vba
  222. Replace Cell values (vba)
  223. Solved: Criteria needing to match several items
  224. Test if more than one instance of excel is open
  225. Cell value dependency
  226. Solved: add to combobox if not already present
  227. Issue with deleting adding
  228. Solved: Open Directory Macro
  229. Solved: None of my buttons work anymore
  230. Solved: Sorting Multiple Rows Horizontally
  231. process array of excel files not working
  232. Solved: Application.GetSaveAsFilename question
  233. Solved: How do you remove all text after the last \ in a string
  234. Count non empty cells on sheet with hidden cols
  235. Solved: Country Name to stay fixed always in a cell
  236. Solved: Password Message Box
  237. Solved: Disable Space Bar & Delete button
  238. Solved: Edit VBA Code using VBA?
  239. Running SQL Stored Proc through VBA
  240. Solved: copy data from one userform to another
  241. Chart
  242. Solved: worksheets function
  243. Problem with multiple users accessing same workbook.
  244. Solved: Delete all code after save
  245. Cell Format
  246. Copy Rows from External Data Query
  247. Use a dynamic range in a formula
  248. Solved: Union Range Error for Pop Up Calendar
  249. Need Help sorting Ratings with or without VBA
  250. Solved: pivot tables