PDA

View Full Version : Microsoft Excel

Pages : 1 2 3 4 5 [6] 7 8 9 10 11
  1. =product(indirect(address((row(j$35)+1-$ai20),column(j$35),true)):j$35)-1
  2. each named range in ??? Ranges
  3. last day of month?
  4. Programmatically adding hyperlinks
  5. Excel function or sub routines available to all excel present and furture
  6. is it instr??
  7. Dash problem in Microsoft Query
  8. Getting Values from Closed Books
  9. Call to open specific file
  10. Close App after certain period?
  11. Calculate the equation
  12. Change cell color based on values of multiple cells
  13. Where is toolbar info stored ?
  14. Calculating minutes formula in EXCEL
  15. share txt file as database
  16. Capturing Open and Close events in Excel.
  17. Display Message when Cell Changed
  18. Rounding & Truncating
  19. Dealing with Seconds in Excel
  20. Copy Data
  21. Entering data from a drop-down list
  22. question about deleting an excel connected to anothers cell formula
  23. Change tab color with conditional formatting
  24. search only one column
  25. pick userform by searched column location
  26. Excel Price Lists into a Database
  27. TabStrip
  28. Problem with VBA in Excel
  29. refresh chart data.
  30. Is there a way to manually sort fields in a Pivot table?
  31. Is there a function that can 'find' text within a cell?
  32. Excel 97/Macro 4.0
  33. pivot tables.
  34. Excel Linked to access
  35. Conditional format colors for multiple cells in VBA
  36. Programatically change name of worksheet
  37. Printing custom views
  38. Word Forums?
  39. Clear Clipboard programmatically
  40. Create crosshairs on top of form using VBA
  41. Launch IE from Excel & control scroll bar
  42. Change the shape of the comment
  43. Excel, Comment
  44. Comment
  45. How to remove a comment in a cell in Excell
  46. Excel's legend additions
  47. New Sheet
  48. dlookup in excel vba....
  49. Excel Checkbox transfer
  50. Excel / Word Automation Help
  51. Changing Font colour conditionally
  52. heirarchical menus help
  53. File open question
  54. HELP on protecting a worksheet
  55. Run a Windows Application from Excel VBA?
  56. How to make a macro a personal macro
  57. Why does #VALUE! show when adding blank cells?
  58. confused
  59. Simple question- Comment font size
  60. division
  61. get source data from Pivot- excel 2003
  62. VLookup
  63. ADO DataSet to Excel
  64. Delete record if cell is empty
  65. Problem connecting to database with ADO
  66. Copy contents if.......
  67. VBA Code
  68. Distinct list of values, and MS Graph sux.
  69. Summing duplicate values
  70. Send chart
  71. Send chart
  72. csv file dropping leading zeros
  73. If Statements in Excel macros
  74. Excel Generating Errors - Recover and Repair
  75. Export from Excel to .pdf format?
  76. Checking if any fields is linked to another
  77. Data transfer between excel files automatically
  78. Help needed, creating a fixtures, results and league sheet
  79. Question about Set = for split ranges.
  80. Linking cells: open source to update values
  81. Shading cell with VBA
  82. Filling out through ADO...speedier?
  83. Help with the INDIRECT function.
  84. Excel date calculation...
  85. reducing file size
  86. Concerting cells to html
  87. Linking cells/adding users to it
  88. using pickists
  89. Making a command button work
  90. user defined import maps
  91. Want to move to another sheet on doubleclicking a cell
  92. Microsoft Excel 2000 and a .mdf
  93. Problems Installing MS Office 2000 Professional
  94. Sorting Issue while protected
  95. Need HELP
  96. Calculated Fields in Pivot Table
  97. Pivot Table Data Items
  98. Keeping recordset open after code execution stops
  99. Most recent file list
  100. CommandBars OnAction Property Fails
  101. copy range from different workbook
  102. Simple problem
  103. filtering data, extract 2 colms to the right
  104. Copying and pasting cells in Excel using vba
  105. Showing One Cell for Each Value
  106. Linking Cells
  107. Find the lowest number and place the number and Column name into in Field
  108. Select Range questions on a macro
  109. Visual studio tools for office?
  110. Disable user interface
  111. Formulas changing when copying to another cell
  112. Inserting comment in a locked cell
  113. Help needed separating data
  114. Status Bar message
  115. EMail Warning Box
  116. Show only required data and transfer to MS Word
  117. Mail Merging Redundant Rows
  118. Excel Error on data refresh to other workbooks.
  119. VLookup data update request is processing before WorkBook_Open event.
  120. Formatting a cell based on the condition of another cell
  121. billions,trillions..
  122. Deleting extraneous rows in text file
  123. Sumif Limitation problem
  124. Money Rounding Problem
  125. importing XML
  126. field Names
  127. Conditional SUMIF???
  128. Remove the minus sign
  129. Find a column
  130. Extracting data within Excel
  131. chart or spreadsheet on userform
  132. import into combobox
  133. If and function
  134. OLE control button
  135. Doing a for each for a whole bunch of cells
  136. Replace C/R with @@@
  137. vba loop query
  138. QueryTables
  139. overwrite prompt.. how do I stop it?
  140. Search Text - Change Color of Text
  141. Vlookup on more than one column?
  142. text as an argument of SUM function
  143. Range Names - creating a list of
  144. Data Validation problem.
  145. vb/excel question
  146. Format error message when opening xls file
  147. Fastest Way to Sort Rows
  148. IF function
  149. Global or Workbook level variables.
  150. Specified sizing for a Pivot Table.
  151. Pie Chart question
  152. Color space conversion from RGB to CMYK
  153. full name separate into 3 fields
  154. Is it possible
  155. Replacing the blank cell by value in VBA
  156. Using VLOOKUP to get at another workbook.
  157. Complicated Query
  158. Excel, Access, SQL or other?
  159. Using an Excel File as an online db
  160. How to surpress OLEDB error
  161. run-time errors 32809 and 57121
  162. Trouble opening an excel file
  163. Merging Cells via VB and Zooming
  164. mouse scroll
  165. Losing My Tabs
  166. Application.WorksheetFunction.find
  167. Cell character limit
  168. Data logging snap shot
  169. Need Help With Excel/Access
  170. OLAP - Pivot Question
  171. File error - Excel export
  172. Emailing Excel Tabs
  173. Menu ??
  174. Bank money in,out
  175. Replacing a cell if it is empty by the value in another cell
  176. Finding Cells
  177. Macro and Worksheets issue
  178. Query table information
  179. Procedure
  180. daily values,
  181. Maybe This is Simple... I need help
  182. Need Version issues
  183. Opening a CSV gives me no options
  184. error in cells.find
  185. Determine cell font color
  186. files exported to excel
  187. Compare data in two columns
  188. VLookup -failing to find a match
  189. loop for i = 2 to ???
  190. looping rows and matching it with an array
  191. VBA Code for Selective formula writing
  192. Advanced filter
  193. Last Updated cell
  194. Excel macros - assigning to cell change?
  195. MS Query security
  196. Sumif with multiple criteria possible???
  197. Dynamic Named Range Problem
  198. importing from excel
  199. HELP[Urgent!!]how to fix the color of the pie slices?
  200. How can you automate export to Access
  201. Turn off autoformatting in MSQuery?
  202. How can i do it??
  203. Date created from file
  204. dividing one cell into multiple cells, possible?
  205. Still having trouble running macro in locked worksheet
  206. check if excel is already open
  207. Can I do this with Excel?
  208. Running a Macro in a locked worksheet
  209. Delete contents from cells
  210. Loop help
  211. Counting row
  212. Another probbly easier problem
  213. Finding next avaialbe row in multiple sheets
  214. Countif()
  215. Finding the Next Available Row
  216. Sheet Protection
  217. Printing Members of an object
  218. Timed Message?
  219. Check if Column Exists in Range
  220. Save some selected colunm values from sheet1 to sheet 2 as new rows
  221. Automated importing process
  222. how can i calculate rating from marks sheet
  223. Multiple VLOOKUP Capability
  224. Help with IF statement in cells
  225. On Change, re-execute a formula
  226. Can I subtotal on more than one group?
  227. Multiple IF statements ???
  228. linking to external excel sheet (newbie at work here )
  229. multiple wkbks show N/A in vlookup cells only when opened together
  230. Remove unexpected chracters-EXcel VBA programming
  231. Printing Members of an object
  232. Listboxes - Linking to external files
  233. Microsoft Text Driver
  234. Microsoft Text Driver
  235. copy/paste speed
  236. How do I use variables in Excel?
  237. copy from one sheet to other and generate a .csv file
  238. Custom menu items
  239. Vlookup and Data lists
  240. Hand held Scanners for excel
  241. Excel Formula length
  242. convert integer to string
  243. Excel Copy Command
  244. Closest Match/Approximative match
  245. Create a Log
  246. Cell Size
  247. Find in column & copy/paste row onto a new sheet
  248. How to hunt through a directory for a file in VBA?
  249. VBA formula limits?
  250. Input Mask On Input Box