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