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