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. Select a column by matching the column heading content?
  2. To be sure looping through all the rows
  3. Looping through rows by colomn name?
  4. Change font in cell based on value
  5. 20 Second Wait tied into a Progress Bar
  6. excel2k FormatConditions question
  7. Problem with printing data from sheet to another
  8. Need differnt cell format from pivot table
  9. Solved: ActiveCell is current/horrible solution... need fix
  10. Solved: Hide/show column base on checkbox caption
  11. Yes/No Validation List with One Condition
  12. Deleting Blank Rows using VBA
  13. Finding Last Empty Cell
  14. To validate date format in Excel
  15. Solved: COUNTIF with multiple criteria
  16. finding the wordwarp charactere ?
  17. If Kill help
  18. Lost Password for Sheet Protection
  19. Hide all userforms that are open
  20. Solved: How to Detect a Time Entry
  21. Setting Value for Checkboxes
  22. How to return an array from a function ? And handle the result after ?
  23. Solved: spreadsheet formatting problems
  24. Keep track of value from another sheet base on time
  25. Password creation
  26. Solved: Two Passwords (User & Master)
  27. Generate list of dates
  28. navigate with scrollbar
  29. Solved: Open VBA Project from Excel Button
  30. select last sheet added
  31. VBA Code Delete Row
  32. Call macro pending on value
  33. What is wrong with this If statement?
  34. Solved: Why doesn't the dialog disappear
  35. Validating set of entries
  36. Solved: length of array
  37. Solved: Passing Worksheets
  38. Solved: userform not catching up
  39. Solved: sumif in vba
  40. Solved: AutoFilter Question
  41. Macro Adjustment
  42. Solved: Combine text data from 9 cells into 1 cell
  43. need help to get list
  44. VBA Open Dialogue Box to Select Multiple Files
  45. Solved: SQL error
  46. Night vs day working hours
  47. Solved: Import Multiple Tables
  48. Spreadsheet in dialog
  49. want to find max time & min time
  50. Disable menus / toolbars
  51. Question from a rookie VBA user
  52. Solved: parsing text & combinations
  53. Excel in Word
  54. Solved: Eliminate prompt
  55. Resize button control when clicked
  56. Pivot table to org chart
  57. Delete Rows from a Range
  58. Solved: better Array support??? to avoid Dim, ReDim, Preserve etc
  59. Error if file exists
  60. A quick copy/paste question
  61. Drop down data validation list
  62. Solved: Run two macros from one button
  63. Solved: SQL JOIN error
  64. Solved: Question regarding Filter function
  65. vlookup error?
  66. Format Cell by Left Click- On and Off
  67. Automation Error?
  68. Solved: using two values from a list box
  69. Solved: check for empty cells
  70. Importing an excel file into a template excel sheet that will enable automation
  71. Solved: Copy and Paste to an Active Cell on a Different Worksheet
  72. need loop code
  73. copy excel to word
  74. heybd_event Info
  75. Sumif and Sumproduct According to Multiple Criteria Function
  76. handle to IE to populate data
  77. Saving data to Access databse
  78. Cell Formatting VBA Help
  79. Help: How to pop-up plot point description when mouse cover
  80. spreadsheet 10 control
  81. Solved: Updating values in worksheet from CSV Files
  82. row and column headers
  83. Advice: Determine Excel in Edit Mode
  84. Forum Rules and HTML Help
  85. Newby-Putting together price build up for quotes
  86. Solved: Count unique numbers
  87. Solved: Copy and paste worksheets to a new workbook, minus the formulas
  88. Solved: NUMBER STORED AS TEXT
  89. Expand a financial statement
  90. Solved: Verify pre-requisites BEFORE running macro
  91. Copying,Pasting,Looping, Confusing!!!
  92. Check to see if add-in installed
  93. Multiple Cells Appear Active
  94. Solved: Pivot Table problem
  95. Org Chart problem
  96. Solved: Passing listview control value
  97. All charts in same sheet
  98. Last Row
  99. Solved: Mapping cells from column to column with UID?
  100. Solved: Need help modifying this code
  101. Solved: Error in Sumproduct
  102. Solved: Help with VBA code
  103. Application.ontime discover
  104. Open/Activate other Excel files from one
  105. Open/Activate other Excel files from one
  106. multiple workbooks with application.ontime
  107. EXCEL VBA
  108. Someone can help me out with writing a simple function??
  109. Resize elements of an org chart
  110. Dynamic Name Range in chart code
  111. excel to access w/ vba
  112. send email
  113. Solved: Sum If I think
  114. Solved: HELP me figure out how to use the formula commands
  115. How to copy many values...comparing with smae values
  116. VBA to copy .txt file
  117. Adjust UserForm Show Location on the Screen
  118. Solved: Limit Blinking Text To 30 Seconds
  119. VLookup with dynamic Filename
  120. Solved: Turning Off Email safety in VBA?
  121. Solved: Dialog Sheets
  122. Removing Close Button on UserForm Caption Bar
  123. Solved: countif
  124. Need help with Import and exporting a file
  125. count a filtered sheet
  126. Solved: VBA Help with Chr(13) problems
  127. Solved: macro slows down each time
  128. Solved: difference between activate and select
  129. Solved: format memory
  130. Solved: application.volatile
  131. Solved: email recipients
  132. Validating a column Head
  133. Scroll through worksheets using spinbutton
  134. Solved: Can a Constant be used as function parameter?
  135. Solved: Drop Down Menu to Display Other Sheets
  136. Function for validating a column name and length of entries
  137. Combine array with lookup in VB
  138. Solved: set reference to addin using code
  139. KB Article not running
  140. Solved: Copying non-sortable data into a new location in a new order
  141. Remove formula / Hardcode Data
  142. Printing All File formats using VBA
  143. Solved: multiple subtotals problem
  144. Search Criteria in User form (VBA- Excel)
  145. Interface Error
  146. Solved: 2003 Excel Listbox ? saving multiple selections
  147. Checkbox code
  148. Color Worksheet Tabs
  149. Solved: What is the mistake in this code
  150. Read current .Find Method settings
  151. peraphs impossible... order line base color...
  152. Open a database using vba
  153. Row VBA questions.
  154. Find Function Fail on Three-Four Letter Words
  155. Axis feature: how to switch off "crosses between categories"
  156. how to automate geocoding & maping
  157. Application.FileSearch query
  158. VBA : select all workbooks and Global FIND/ REPLACE
  159. Solved: Range Copy problem
  160. Solved: Alter code for macro to all worksheets for duplicates
  161. Disable Save from Ctrl S
  162. How to determine that category axis is related to time?
  163. Page Break Help please
  164. Solved: Filtered results to userform listbox problems!
  165. How to quickly count number of lines in a CSV or Text File?
  166. Need Macro to convert formula to value
  167. Solved: Keep date look in the result of a formula
  168. What is wrong with my code?
  169. Solved: What is wrong with my Validation code?
  170. Solved: UserForm Help needed
  171. SELECT A EXCEL ROW USING MACRO VBA
  172. Need userform to perform search and calculate
  173. ComboBox - Highlight default when userform loads
  174. Help me please
  175. Solved: Find Then Unhide Help
  176. Change Tabs in the Ribbon
  177. Solved: Help with Chart Lines
  178. Solved: Problems calculating static dates.
  179. Why Data Validation is not working?
  180. Seach Worksheet Names and Return Data
  181. Embedded Ppt in Excel Doc
  182. Filter Top 3 and display them in another sheet
  183. Assign Formula to Chart Sheet Text Box (migrating from Excel 2003 to Excel 2007)
  184. Changing an existing formatting macro
  185. Sheets Selection Through Combobox
  186. Solved: Delete Code After Copy
  187. Macro Edit
  188. custom random array
  189. Excel VBS SQL Code Problem
  190. Format with different colors
  191. VBA: how to interpret this code?
  192. Email, CSV, VBA
  193. Solved: Parsing?RegEx? Finding 1st character after 2nd Dash "-"
  194. Solved: Reduce x number of 'with' loops using code to update ranges from userform entries?
  195. Solved: Problem in Month days Calculation
  196. vlookup maybe ?
  197. Increase of the EXCEL.EXE memory
  198. comparing dates in vba
  199. Disable all textboxes in a userform
  200. Row Search & paste string
  201. Solved: Store a sequence of numbers in an array and recall them as required.
  202. Final Row help
  203. Need help with this Function code
  204. Need help with this Function code
  205. Solved: Save a sheet in workbook to a specific folder automatically
  206. Solved: Looking for a KB
  207. Solved: How to determine the axis title width?
  208. Add-in question
  209. Alternate row colours within a Listbox
  210. vb statement
  211. Solved: Retrieve value from chart data label
  212. Solved: Returning the Path of a Shortcut as a String
  213. Just checking the month
  214. Solved: Find and convert unix timestamps
  215. GUID for Excel 2007
  216. Tell VBA script to look for info in a cell
  217. Save As Location
  218. Multiple Filter
  219. Macro to add sequential WS and update summary
  220. Format entire column
  221. VBA Cell Format based on In-Cell Formula Result
  222. Copy specific data
  223. Solved: Copy data from multiple worksheets in a workbook
  224. Solved: Force users to enable macros in a workbook
  225. Solved: colornumber in excell
  226. How to auto log-in into IP Address using vba
  227. Counting Dates
  228. Please Help in Converting Excel spreadsheet to access 2003 table
  229. Solved: Triple Value Check Boxes
  230. Solved: Problem with save texts of UserForm.ListBox
  231. sort worksheets by tabcolor
  232. How to Make CountA Function Not to Count Hidden columns data
  233. Searching for a Consensus sequence
  234. Do Not Refresh
  235. How do I ignore Saturdays and Sundays with Autofilter?
  236. Exporting an Excel file to a text file with format .txt
  237. Need remote control vba help for my classroom
  238. Help: How to update all imported data in Excel
  239. Bind a key to a macro
  240. delete all comments
  241. Solved: copying ROW numbers into an array
  242. Critical Path Analysis
  243. Solved: Newb to vba need help with trig
  244. compare 1 out of 1,600,000
  245. Variable scope
  246. Adjust the CurrentRegion when copying
  247. Solved: Loop files on shared folder
  248. Error help BeforeClose
  249. Userform hidden and my macro stops
  250. Solved: Excel: comment pulled from cell text?