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