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. How to search and modify existing record
  2. Solved: Code runs on other open workbooks
  3. Solved: Calendar Form pass control back to UserForm
  4. Conditional format
  5. right click copy
  6. received time to excel
  7. Program cells and allow manual input
  8. applying formula on active cells
  9. Solved: Limit input characters in a cell
  10. Investigating a more object orientated approach to doing formulas, need help
  11. Code to Group Worksheets on Open
  12. Excel 2007 After Password Entry Not Changing Permissions
  13. Web Query to grab zip codes from USPS
  14. Solved: Formula to use for picking out the first of a common reference.
  15. How to replace word character to excel character
  16. Conditional formatting again
  17. Writing Vlookup w/ dynamic 'table_array' in syntax
  18. VBA report formatting
  19. Copy to a specific cell
  20. limit records in import/linked data
  21. Solved: Delete rows if part of string is not xls, doc, txt or csv
  22. Protection
  23. Filter By Listbox Criteria
  24. Filtering out unique items and summing up values only once
  25. Solved: delete some columns and add borders using macro
  26. Solved: Password Protect Excel 2007 Workbook
  27. Number To Letter
  28. Solved: Formula help
  29. How to read the contents of an OLEObject (dropdown list) in excel
  30. "Excel 2002 Search Macro Help"
  31. SMTP emailing
  32. Solved: limit scroll area in all version of Excel
  33. Solved: Multipage versus multiple forms in Excle
  34. Solved: Calendar in Userform
  35. Weird problem: Quick Access Toolbar with scripts can't be saved on local hard drive
  36. Solved: Transpose data from one sheet to another
  37. Solved: Excel on double click event help
  38. Go To Sheet
  39. Please password protect my file
  40. default dropdown by region?
  41. Excel to Outlook
  42. Comparing 2 Columns
  43. Older posts
  44. Solved: Sequential unique numbering in excel
  45. Read xml File into Recordset
  46. Copy Chart from Excel to Powerpoint
  47. Replace Dates with Text in a formula
  48. Printing Unique Records
  49. The Control Named X does not support saving?
  50. Deleting Blank Rows
  51. Help on #N/A error
  52. Solved: Copy This Formula Down Rows
  53. Why does VBA slow down on this?
  54. Solved: Combobox Highlight Causing Readability Problems
  55. SUMIF with two conditions
  56. regarding IF commands into VBA
  57. Solved: Fast Cut and Paste
  58. sum the numbers under criteria
  59. How to Display Embed Objects in Sheet?
  60. Delete Specific Rows
  61. Compare 3 columns and delete the duplicates
  62. Problem after removing PDFCreator
  63. Solved: Is it possible for excel to execute a command like add files to a zip archive?
  64. how to use vba to automatically download a file
  65. How to change a date in one sheet and it add a value in another
  66. VLOOKUP question
  67. Import CSV using ADO - Missing negative values
  68. Solved: excel delete a workbook
  69. Solved: Listing all files in directory including zip files
  70. Changing line color of a graph with VBA
  71. Solved: Checking the value of a check box
  72. Use calendar to get value from selected date
  73. Commandbar ComboBox
  74. Font Color Index
  75. Lookup Help
  76. Solved: Using cmdbutton.caption in msgbox
  77. How to Use the Format Painter Selectively
  78. Exchanging argument values between macros in different wokbooks
  79. Toggle bold button
  80. Flag Rows Randomly after Applying Filter
  81. remove duplicates and transpose columns to rows
  82. Help with VBA code for single selection listbox
  83. Hide/Unhide sheet based on cell value
  84. Change name of VBA Created button
  85. VBA Run a Macro while staying on the same sheet
  86. Moving Cells within a spreadsheet
  87. Update Macro
  88. Create a Const that references a Range
  89. With Statement
  90. Solved: Required Cells Before User Can Save activated by a trigger
  91. Solved: Restrict specific words from a column
  92. Solved: Lotus Notes to Excel (If, your looking for a Challenge)
  93. search and copy to another sheet
  94. removing duplicates from table in memory
  95. Solved: Help - Select Case ActiveControl.Name
  96. Format cells
  97. problem running vba in excel
  98. copy and search
  99. help with vba calculation on several columns based on row.
  100. Solved: Help required on Filtering a Pivot Table
  101. Solved: Copy Module
  102. making calculation on named range col but returning col number total
  103. Solved: Date formula
  104. Fixing postal addresses
  105. Increment in date value if time exceeds a particular value
  106. STOPWATCH
  107. Formula help
  108. UpdateLinksNever when Adding Template
  109. Excel 2002 Find and copy to another worksheet"
  110. Conditional Formatting for Constantly Changing Spreadsheet
  111. Solved: sort activeworksheet, out of range
  112. Making a chart's x axis dynamic
  113. Solved: paste file name in all rows of a column
  114. Link to another workbook and find duplicate entries
  115. Autofilter with VBA
  116. Command Button to send SS as E-Mail
  117. Search entire column for word/phrase and list results
  118. Solved: VBA to find last populated cell but ignore formulas returning blank
  119. VBA PLOT JUMP ROW
  120. Solved: VBA inserts spaces into formula
  121. Open, find and replace in notepad++ using VBA script
  122. Count Formula
  123. Create Macro - Select Range?
  124. Vba help
  125. Loop link to spreadsheet.
  126. message box format
  127. loop help
  128. simulating keystrokes
  129. Excel Spreadsheet to Word UserForm
  130. using VBA instead of fomula in the sheet due to multiplie calculation
  131. Worksheet function Sum in Excel VBA
  132. multiply names in variable (userform)
  133. Activating Hyperlinks
  134. Solved: vba delete entire row
  135. Face IDs and Buttons
  136. How to add rows to tables using macros
  137. [VBA - UserForms] Adding
  138. overflow runtime error
  139. Solved: check box logic
  140. Filter rows on sheet 2 when a certain option is chosen on sheet 1
  141. File is not a recognizable format
  142. Solved: Menu?
  143. Events
  144. Extending COUPNCD for monthly payments
  145. Excel Password Recovery
  146. Rename Worksheet Tab in UPPER CASE
  147. Change formulas to values, but with some exceptions
  148. Solved: Save file with worksheet name
  149. Macro to Select Range and Copy
  150. populate comboboxes multicolumns ignoring empty filds
  151. i have a problem about fields of executed query in vba
  152. vlookup or something else
  153. Copying Down Formula using VBA
  154. Logo Place Holder
  155. Solved: Identify Unique Cells In Range
  156. Solved: Remove Duplicates
  157. Solved: Cleaning up a list.... direction please.
  158. VALUE = NOTHING
  159. Solved: Possible for excel to detect inactivity at pc?
  160. Solved: trigger msgbox once
  161. Toolbar macro won't run
  162. Scrolling down a list to find a specific number
  163. global arrays are reset after pasting images from another sheet
  164. getting file path of image
  165. Solved: delete part of string in every string
  166. Solved: convert formula to VBA
  167. Solved: delete content after save
  168. Entering data in next empty row
  169. Solved: Excel VBA - Save As with Password
  170. Recognizing Time > 24h
  171. Excel VBA Help
  172. click save csv files
  173. extracting phone & fax #
  174. Solved: Date stamp in column L if forumlua in column W = 1
  175. dynamic graphs
  176. Solved: VBA to Hide Toolbar
  177. Solved: upload file
  178. Solved: combine multiple workbook become one
  179. show me the way to the next ...
  180. delete workbook after a certin time period
  181. Solved: Have code check for 2 sheet names and copy values from them
  182. Excel attachment with lotus notes
  183. Solved: Compare columns in different excel files
  184. How to close FORM in ANOTHER WORKBOOK
  185. Question about CountA() and dynamic named ranges
  186. Solved: Formula help again
  187. Hide/Unhide rows - NT login
  188. Solved: Exit and Exit Full Screen
  189. Solved: How to do repeated File-Open commands in alternate locations
  190. Solved: Sort Defined Range
  191. Can I use IF function and run a macro?
  192. Refreshing External Database Query In Excel using VBA
  193. Solved: Formula take 2
  194. Hiding, Copying and pasting in a specific order
  195. Remove Conditional Formatting
  196. Solved: How to Exlcude some charts from Macro
  197. Solved: KB Article
  198. Application.InpuBox restriction - input 1 cell
  199. Excel 2007 Clear Cache at run time?
  200. Solved: Counting Substring Presence in Range
  201. Automatic Select Based on Cell Value
  202. Solved: encounter error
  203. Linking Excel Cell with Text Box
  204. How to do Multiple If Statements Shortcut!
  205. Disable cut/copy/paste - but still be able to copy between workbooks??
  206. Pivot Table VBA
  207. Solved: Run Time Error '76'
  208. Solved: Copy files given location to a new location
  209. Solved: Save as 'todays date'
  210. IFS, ORS, ANDS???
  211. Solved: Issue with applying a name to a range in autofiltered table
  212. Controlling IE sub documents from Excel VBA
  213. Form Picture help
  214. date problem on a form
  215. autofilter problem
  216. setfocus on a form
  217. calculation col and rows min and max values
  218. Solved: Changing color of item in listbox based on value of specific cell
  219. Linking Password Protected Workbooks
  220. Solved: Hiding Columns if all cells = zero
  221. encrypted macros
  222. open a file based on a modified date
  223. Disable userform.show
  224. [SOLVED] Locked cells - values from macro
  225. APIs in VBA Help
  226. return specific values
  227. Solved: Setting a range to the result of a formula
  228. Accessing a Database through VBA
  229. opening new instance of Excel when opening file
  230. Solved: remove vba
  231. Array Help
  232. Tidy up of code required
  233. how to force paste-special values in excel
  234. Selecting typical Data and copying in a new sheet in other format
  235. Best Match
  236. Solved: finding if two controls overlap
  237. Solved: Combining two bits of vba
  238. Solved: conditional formatting VBA
  239. Hide Horizontal Scrollbar
  240. Find value and copy value from another column
  241. Solved: Create chart based on current month
  242. Conditional formatting for entire row for text based values using VBA code
  243. Compare two worksheets
  244. Load list of ftp files from directory into a userform?
  245. Solved: Update UNLOCKED cells on a different sheet?
  246. Sleeper: Excel Macro - Word doc as message body images
  247. Solved: combine all workbook
  248. Callng a sub from another sub
  249. Solved: only numbers
  250. Excel crashes when calling Doc Readystate