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. specifying range when returning an array
  2. [SLEEPER:] VBA Code for clicking a link?
  3. Solved: Speed up or new code for deleteing rows
  4. Solved: Run time error 424 - object required. Why?
  5. Sleeper: Copy rows to worksheet two
  6. Solved: naming sheet after cell value
  7. Opening embedded word document through VBA
  8. problem deleting rows based on a condition in another workbook
  9. Solved: Assistance with character counting (Excel '97)
  10. Solved: Automatically import data from Access DB in Excel
  11. Multi-condition function
  12. Microsoft Query hangs
  13. Checkbox checking...then unchecking on its own?
  14. Change to "SKIP BLANKS" when pasting?
  15. Macro to sort Ascending,identify duplicates& highlight yellow
  16. Solved: Application.Help doesn't work on terminal server
  17. Looping until a Frame is ready?
  18. Listbox Question
  19. initialize 2d array
  20. Switching workbooks in VBA
  21. [SOLVED:] Change Check box Value to Text
  22. Solved: Need help creating a function with loop.
  23. I need help with a code to change the scale of a bar chart.
  24. Copying Forumla Down In One Column
  25. Code execution has been interrupted
  26. Solved: Times Now & Rounding
  27. Solved: Autofilter, copy and paste into new sheet problem
  28. Solved: Paste Listbox Variable to cells
  29. VBA Code runs too slow
  30. Solved: Hyperlink in a Userform
  31. Solved: Infamous "Excel cannot complete this task" message.
  32. [SOLVED:] sending data to powerpoint charts table
  33. Solved: [Excel 2007] Apply custom number format based on column header
  34. Solved: Error when clicking "Cancel" Button
  35. Solved: Multiple Questions (Chiinv function & dragging cells)
  36. Solved: Sumif Concatenate VBA code
  37. Solved: Charts & Ranges
  38. Solved: Generating a 1 or 0 randomly with frequency l
  39. Solved: Help with VBA code
  40. Solved: Comparing elements in 2 arrays
  41. Chart
  42. Solved: Userform;TextBox:Update Data
  43. Excel 2007, Aditional Controls
  44. Solved: returning the previous tuesday at 2pm
  45. Help VBA - Importing Data
  46. Hide subtotal row in pivot table
  47. Sending email using Loops/If Then?
  48. Solved: Looking to change a character to another...
  49. Solved: Select chart series with option button
  50. [SOLVED:] Filter criteria in active column
  51. Hide rows in excel
  52. [SLEEPER:] Send Keys does not work in my remote application
  53. Solved: IsNumber question
  54. checking for space bar
  55. GUI Excel
  56. Copy paste data from activerow into existing powerpoint presentation
  57. Solved: Import Spreedsheet from a closed workbook to another workbook
  58. Solved: Count if two criteria meet requirement
  59. Copy Range From External Workbook to Range in Open Workbook
  60. Sleeper: Convert all excels files from a folder to pdf
  61. VBA Excel (variable range) help
  62. [SOLVED:] Format only blank cells in the range
  63. [SOLVED:] Getting rid of a popup on closing a workbook
  64. Replacing in VBA
  65. Solved: Sending email using 'IfThen'
  66. [SLEEPER:] Multiple commands in BeforeClose
  67. Solved: Formatting Macro Problem
  68. Copying sheets multiple times in the same workbook
  69. Solved: Find Replace from external file
  70. Sending Birthday Greetings via Email using list of addresses in Excel Sheet
  71. Remembering a file path ...
  72. Double Click Table Header to Sort
  73. Solved: Need help te create formula or vba code
  74. item.send security dialog box
  75. Solved: Creating File Path for Hyperlink
  76. SORT COLUMNS VBA
  77. got following error after export excel file .
  78. Message Response Loop Problem
  79. Pagesetup and set PrintArea for multiple ranges and sheets
  80. Solved: Code Help for FX conversion and formatting
  81. Macro Toolbar, disable buttons
  82. Creating and renaming work sheets to correspond with worksheets of a nother WB
  83. Line Graph
  84. Intersect with multiple ranges
  85. macro help
  86. Copy Active sheet to new workbook.
  87. Pass form Object to Function
  88. Solved: Copy Sheets to a New workbook
  89. Solved: Close Sheet after Copy
  90. Solved: Enable command button if in group of option button one option is selected
  91. Create range of only duplicates from another range
  92. SearchFind = Nothing in Union &/or Intersect
  93. Test what formula is in a cell and change it Excel 2007
  94. Solved: A quick Sendkey question
  95. Solved: How to make spreadsheet tabs invisible but not hidden
  96. Excel VBA Row Generation if Value Exists
  97. Solved: Deleting Autoshapes with vba
  98. put clipboard as variable
  99. Filtering an ADODB recordset
  100. NEED HELP IN LINEAR PROGRAMMING PLZZZZ
  101. Solved: Cell contains certain text, delete row?
  102. from excel formula to vba ...
  103. Solved: Offset Function Question
  104. Solved: How to stop an 'on_change' subroutine running if I make a change via another subrouti
  105. solved: Excel VBA Removing duplicates
  106. Solved: Copy range help
  107. Combining two VBA processes
  108. Report creation
  109. Solved: Only use CommandButton Once
  110. grouping tasks
  111. Delete rows except user defined criteria
  112. [SLEEPER:] Pull .xls from google docs via vba
  113. Solved: Search for an Excel field
  114. Solved: Close workbook and quit XL
  115. Search form in excel
  116. how to hide excel toolbars from macro enabled file
  117. Solved: Form Question
  118. Categorizing data
  119. Solved: If statements
  120. [SOLVED:] My "do while" loop doesn't complete
  121. Solved: UserForm Import Form
  122. [SOLVED:] Excel and Bloomberg
  123. Solved: VBA pastes in wrong range
  124. Solved: Subscript out of range (Error 9) VBA Code works on one computer but not the other.
  125. Help with the error
  126. [SLEEPER:] Integrate Excel with AD.
  127. stupid F8 in excel 2003
  128. VBA Macro Conditional letter generation
  129. Help with disabling Macros in another workbook
  130. Solved: Further Help with Code
  131. Help needed Macro Runs after userform is closed
  132. Mail the current workbook to different recipients on condition
  133. [SOLVED:] active cell formula typing
  134. Solved: RANDBETWEEN FUNCTION
  135. search first value in range
  136. VBA script to verify that file size is increasing
  137. How to know if multiple cells were selected
  138. Conditionally Populate Value in Rows Using List/ComboBox
  139. find if cell value changed
  140. Solved: WEEKNUM - Excel 2003
  141. [SOLVED:] How to split a PDF into pages using VBA
  142. Solved: Updating Cell Info
  143. Not able to copy a VBA array with formulas into an Excel range
  144. split a variable
  145. Solved: Path to macro
  146. Pivot table trouble
  147. Excel 2003 SP3 (Excel11) problem
  148. Solved: Updated data should export to Create Task in MS-Outlook
  149. Solved: Formula for Date Ranges
  150. Solved: Reset Button duplicates combobox list
  151. Pass String to Word macro
  152. Writing to specific row using matching criteria from user form
  153. Solved: personal.xls
  154. Solved: Problem writing formula
  155. Solved: Copying cell content if target cell is blank
  156. Copying a worksheet content to 19 other WSs in the same WB
  157. checkbox size
  158. Solved: Display user name using msg box function
  159. Solved: Find the numbers out of sequence
  160. VBA code for Shared workbooks
  161. Solved: Formula gone wrong
  162. using inputbox data
  163. CODE HELP
  164. Error: Too Many Different Cell Formats
  165. Solved: Formula with { & } at both ends
  166. Run time error 1004 - Application defined or object defined error.
  167. [SLEEPER:] comparing text
  168. textbox default value
  169. Calculated field on pivot
  170. vlookup / match / concatenate??
  171. Blank line at end of file
  172. Search for empty column / paste values only?
  173. Range Position and link to ranges
  174. [SOLVED:] Print multiple sheets to virtual printer as one print job
  175. 2nd criteria filter-search in lisform
  176. VBA Macro Creates Scatter Plot in 2003, Adds Lines in 2007???
  177. Pivot table using 4 other excel books for data
  178. How to clone a class?
  179. Changing a checkbox value
  180. Solved: Todays Date Name in VBA
  181. Can I send a CDO message via a Proxy Server ?
  182. Array Type Mismatch
  183. Load colours from another sheet
  184. Solved: Generating a Pivot thru VBA (Summary)
  185. Error handling declaring public variables
  186. Using Sumif in a Macro
  187. Solved: Find Greater Than
  188. VBA code to search & open file in FTP directory
  189. Switching between Excel instances
  190. Solved: comment used to track changes
  191. Insert Hyperlink in Cell using Text Box
  192. Protect only selected cells
  193. Solved: Break up total months into years and month
  194. Fixing worksheet in place
  195. Pulling Data into Excel from IE Javascript table?
  196. Can you tell if a cell has Data Valdidation Circle?
  197. Solved: File Count in Directory
  198. Hide Protect/Unprotect Sheet
  199. Show userform while macro runs
  200. How to change cell data in excel by reading data from another file
  201. Solved: option button help
  202. Very Basic Loop Question?
  203. Selecting rows in viewable filters
  204. Solved: Calculating weighted average using macro
  205. In Cell Drop Down List
  206. Solved: Server moved, macro failed
  207. Find similar part #
  208. Multiple IF else formula not working.
  209. Clear All Command Button in User Form
  210. Solved: Open a workbook from a path stored in a variable
  211. Protected Cells
  212. Comment box style help
  213. Switch the active Window ...
  214. Solved: Nesting in a Private Sub Worksheet_Change
  215. Double lookup
  216. Listbox Header
  217. [SOLVED:] UDT initialization
  218. Solved: Adjusting the last digit of a number with macro
  219. Loop through auto generated filter by variable (Help needed!)
  220. Solved: Userform textbox - random numbers (Excel '97)
  221. Solved: Excel 2007 Add-ins
  222. Retrieve data from Outlook
  223. Solved: Simple way of moving all files in a folder
  224. RefEdit issue
  225. Solved: Search for possible combinations of values
  226. Solved: Clear Contents in all worksheets in workbook
  227. Solved: extend range of cells
  228. Solved: Highlight Numbers
  229. Activate an 'Add in' in a macro
  230. Solved: Dynamic field parser/importer
  231. Solved: Changing column values to negative and in descending order
  232. Format Chart Data Lablel based on Target Value/Goal
  233. Selecting a Range of Dates with a Specific Month
  234. Rand Select Unique Values
  235. TextAlign for specific columns in a ListBox
  236. Solved: add column values
  237. Code help with Aggregating Statements
  238. Search for keyword within a keyword search
  239. export selected worksheet into dbf format
  240. Solved: Remove Empty Cells from Range, Copy and Paste
  241. Solved: more if condition in one formula
  242. ActiveChart.SeriesCollection(x) Referance
  243. Solved: Changing the settings of a combobox
  244. Solved: Highlight cell from link
  245. Solved: Move rows to new sheet based on condition
  246. Solved: Emailing CC. recipients
  247. Solved: Sort Data and color code
  248. Solved: Inserting Rows after a count
  249. Solved: lookup the 4th characters in a cell
  250. Solved: Sinple question regarding calculating a due date...