PDA

View Full Version : Microsoft Excel

Pages : 1 [2] 3 4 5 6 7 8 9 10 11
  1. Is this a Lookup or something else?
  2. Conditional Formatting
  3. Need to exclude certain metrics
  4. Runtime error 13 'Type mismatch'
  5. Show progress on statusbar while pulling data from sql to excel.
  6. Object Required Error when setting value
  7. Pivot chart question - display totals
  8. VBA to refresh data upon opening workbbok and VBA to automatically fire upon Refresh
  9. add - to cell data
  10. ALTER TABLE syntax issue
  11. Excel to Access Help
  12. Change names
  13. Current Value
  14. Finding the correct worksheet---Help!
  15. A Simple question.
  16. conditional formatting
  17. Creating Add-ins in Excel
  18. OWC11 spreadsheet addcomment to cell
  19. Please help need urgent help
  20. Variable Ranges and Combining Data & Text
  21. Delete all records after "/"
  22. Protecting from editing...
  23. Run macro for rows that are not grouped?
  24. Help with a Mystery
  25. Pivot Table EnableMultiplePageItems in Excel 2003
  26. How to Return Unique values in VB - Excel
  27. Deleting Macros
  28. Interesting problem pls help
  29. Ignore Duplicate Data
  30. Excel formula. finding the last 10
  31. Compatibility Mode - Unprotect worksheet not working
  32. MSGBOX active cell and custom msg
  33. Excel Date Issue
  34. Range("A1").Select causes err 1004 Application-defined or object-defined error
  35. Adding worksheet data into another
  36. insert values from excel to sql server
  37. Problem with plotting series along secondary Y-Axis
  38. Using result of drop down list to perform multiplication, based on table of values
  39. Should I use Excel for this database?
  40. IF Statement Comparison in Excel spreadsheet
  41. Type mismatch error
  42. Populate a comboxbox and Listbox in a excel userform with an sql table data
  43. A macro to authorize a user to run another macro.
  44. A macro code to check whether any workbook is currently open or not.
  45. How to use different Face ID's in a Toolbar.
  46. Countif multiple cell criteria
  47. Copying userforms in Excel
  48. Turning off Compatibility Checker in Excel 2007
  49. Free send mail?
  50. Sum of values in frequency's
  51. Link path change
  52. To upgrade or not?
  53. Question about formula for time change
  54. insert a blank row macro
  55. Store current date & later on user in cell
  56. Find Copy Macro which contains "xyx"
  57. AdvanceFilter in Macro
  58. autofill problem in macro
  59. convert excel function to vba
  60. Where to start?
  61. My Excel Read-Only file will not open in maximized view.
  62. Hide tabs from specific user(s)
  63. Conditional formatting on Change of Cell Value
  64. Find, Copy and Paste Macro Help.
  65. Lookup data
  66. Convert Data type
  67. Copying and pasting discontinuous cells
  68. Select active cell
  69. Wordsearch function
  70. Run a Macro when a cell is selected
  71. checking whether a value is within a range
  72. Vlookup and if
  73. Find Next Empty Row
  74. Calculation Issues
  75. Formula to return the decimal of a Value
  76. Format number as text on multiple files import to a Single Workbook
  77. rearrange columns in all the sheets based on column header
  78. Data Type Mismatch in Excel ODBC
  79. Child, Mother, Father
  80. String Function in Excel ODBC
  81. Data between dates
  82. Parsing text strings to words
  83. Charts Issue With 2 X Axis
  84. Refresh pivot on start-up
  85. Get Min & Max date from Pivot table field
  86. Compare values and move data to new sheet.
  87. CONCATENATE - limits?
  88. Set "Save As" file path
  89. Clear contents of cell if clicked, then repopulate if nothing is entered
  90. modify cell contets
  91. Generic DISTINCT question, but I'm querying XLS
  92. VBA form - search and export row
  93. Data/String into an Excel Cell using VB
  94. Check for a value in a cell - find match in sheet2
  95. If Function with Time Format
  96. If formula (Scratching my brain)
  97. Column counts w/Look up cells & #N/A
  98. Counting instances of specific value
  99. Creating individual logins for mulitple worksheets (VBA),
  100. Marco to hide blank rows
  101. Check boxes
  102. Find Duplicate; Copy; Paste
  103. is it possible to access/write database ms access 2003 .mdb at the same time?
  104. Excel links to TimeSlips (Paradox) and QuickBooks?
  105. VLookup to find data from filtered rows
  106. personal function
  107. Linking Access DB to Excel via MSQuery (VBA Question),
  108. Help on PivotTable..
  109. Subtract Datetime
  110. How to get current path then do the linking
  111. multiple rows of text from notepad
  112. SUM column totals when there's #N/A
  113. Forcing column datatypes, but allowing user entry
  114. Can't see message bar with security warning
  115. Replacing the False in vLookup with a Dash
  116. Macro to identify & consolidate same value cells
  117. Workday function to find specific date ?
  118. Minimising the Ribbon
  119. Using vba for custom formulas
  120. Excel SendKeys CTRL+TAB
  121. Insert file path in footer
  122. Code exection & Worksheet functions - synchronous or asynchronous ?
  123. Assigning Range - Relative reference Vs Worksheet reference
  124. Iterate Code Modules
  125. Egregious hyperlink behaviour
  126. Multi Page control
  127. Sendkeys
  128. Find records
  129. Help with Pivot Table - Source data & Calculated items
  130. Lookup array of values
  131. Reference Label on Worksheet
  132. excel game
  133. Excel VBA Function...Can someone explain this function to me?
  134. Convert Excel2007 database to Works 9.2 database?
  135. =SUMPRODUCT((Data1!$B$1:$B$500="March")*(Data1!$C$ 1:$C$500="New York"),(Data1!$E$1:$E
  136. conflict between auto save&close macro and show/hide sheets macro
  137. Excel error help
  138. number to string
  139. Tweeks to improve macro
  140. Please Help!!!!
  141. Basic excel query!
  142. MS Excell - Nested If issue -Amateur
  143. Horizontal axis stuck to 0 line
  144. Horizontal Match
  145. Opening an Excel file from network
  146. Query help
  147. Stop a Macro Running twice
  148. using offset?
  149. Long string in Excel cutting off in mail merge
  150. Data Validation Problem
  151. Print preivew from page # doesnt work
  152. Call up excell workbook from with DB through on Click
  153. pass values from excel worksheet to VBA array
  154. SUMIF function returns no result
  155. Tab Color If Statement
  156. how to insert null record in excel sheet
  157. CSV over 200,00 rows but Excel 2007 not importing
  158. Help with monstrous formula from H*ll
  159. UBound: Type mismatch in VBA function
  160. sorting data in more than 3 columns
  161. Restrict / Provide access to users to a macro through a sql database list.
  162. Userform in Excel with Remember Password and User id option or check button
  163. Bloomberg Copy Screen/Excel VBA Problem
  164. Create ageing periods (eg 0-30, 60-90 etc) Excel 2003
  165. if formula to check if the number is in a certain range
  166. Querying MS Access data from Excel
  167. Rowsource for userform in Excel add-in not working
  168. Income Oppertunities from Home
  169. Function to get the current path/directory
  170. returning a cell's address from the results of a VLOOKUP
  171. Formulas not updating for no apparent reason
  172. Selecting Subgroup based on specific Group
  173. Parse Name from one sheet to another
  174. CUMULATIVE COUNTIF...sorta
  175. userform cascading combo box
  176. macro to select row
  177. Getting dd/mm/yyyy mask to apply to an InputBox
  178. Date format problems in excel
  179. Adding numerical values of letters
  180. Problem with Move Selection After Enter
  181. Excel - Importing External Data
  182. DOS Command/Batch File: Syntax to call variables
  183. Prevent leaving Excel window while code runs
  184. referencing multiple worksheets
  185. Taking data from three workbooks combining into one workbook.
  186. Referencing External Workbooks
  187. Line Weight
  188. Filter a multi demensional array?
  189. VBA help on .AutoFilter results
  190. Open form to specific record, create new record if it does not exist
  191. Read Range values to array
  192. Excel Date conversion
  193. How can I stop this template from locking up
  194. Webbrowser Help
  195. help with Connection string for Progress 9.1D
  196. If statement to delete rows ending at last row
  197. Several macro files running at the same time - will it cause conflict?
  198. Get an instance of a sheet from codename string?
  199. Autofill Problem
  200. Set order of sheets in a work book
  201. Grouping and unGrouping colums
  202. create array from range of cells
  203. Count Multiple Columns
  204. Formula When Exported From Access Doesn't Work
  205. Need To Create Row Reference Not Knowing The Row
  206. Outer Join and Inner Join with 3 tables in MSQuery (Excel 2003) linking to Sage 50
  207. Printing with Named range faster than Address?
  208. Cycle cells in Given Range
  209. Excel Drop Down List
  210. How do you create a % format type?
  211. Excel 2007 Add-in to save DBF
  212. help in temp tables
  213. copy & paste
  214. VLOOKUP Problem
  215. determine if a sheet name exists
  216. Exporting data to Access using VB
  217. donīt manage to send an image backward ......
  218. Using a Userform to obtain value for use in macro
  219. Link a table to another table?
  220. MS Query using "contains" and "prompt"
  221. Convert number into text
  222. JOIN 2 WS into one
  223. Deleting Multiple Data
  224. Filter a multi demensional array?
  225. Month display on pivot, plus variance column
  226. Resizing an array
  227. Error 438
  228. Data validation depended on IF statement
  229. managing a payroll
  230. Any ppl can help on Database with user form
  231. Filter an collection of objects?
  232. Stop all code from executing
  233. Edit Record In Access from Excel Using VBA
  234. Trouble displaying access table in excel macro
  235. Comparing multiple values and counting if criteria meets
  236. loop control issue
  237. Excel IF and vlookup formulae
  238. Using error handling in excel
  239. Nonprinting characters
  240. INSERT INTO statement having local variable and SELECT statement as parameters in VBA
  241. All the code
  242. returning a variant matrix Subscript out of range (Error 9)
  243. using a matrix
  244. What to use for a string enum? Read only class?
  245. my 1st class what am i doing wrong?
  246. ISNULL? isnull(myArray(1,0),myArray(1,1)
  247. declaring a multidemensional array
  248. color fill
  249. GetSaveAsFileName Question
  250. Grab only numbers out of a text string (MS Access)