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

  1. Time Capture To Log Files using VBA
  2. Excel Formula
  3. Excel Formatting in VBA
  4. Solved: MS Query and Excel
  5. VBA problem
  6. save excel file with different icon
  7. Solved: Loop Through WorkSheets: Help Needed
  8. Solved: Add Border to last Row
  9. Solved: VBA Macros Problem
  10. VBA Duplicate Name Check and Calculating the Values
  11. Sorting through two lists
  12. Solved: Formulas, Code, and my ignorance....
  13. Import a plain file of data into tab
  14. Solved: File Save As
  15. Special type of excel files
  16. Solved: Looping through all workbooks in a folder?
  17. Solved: date format problem with macro....
  18. Solved: File name in status bar
  19. Save a single sheet
  20. Solved: Expand/Contract a User Form
  21. Solved: command for Sheets("All")??
  22. Solved: How to add a data label to a bubble in a chart?
  23. Running a Word macro from Excel
  24. Solved: my desktop / your desktop
  25. Using word file between userForms and readonly
  26. Solved: Looping Through Cells
  27. UserForm tables
  28. Solved: quick question formatting column widths
  29. Solved: Help with ComboBox not in userform
  30. Vertical like through point
  31. Solved: macro timer
  32. Solved: Making a Custom Table
  33. IP Address Location and DNS
  34. Free VBA programmingf Add-ins?!
  35. Convert String to Range
  36. Offsetting Multiple VLookups with Picklists
  37. Need to change text of .CheckBox through a counter
  38. find duplicates
  39. Insert new row and add Title for new row
  40. Solved: Writing code by code
  41. Clean Files names on a list, compare and signals missing files
  42. Paste range to fit one page in word.
  43. Solved: need help
  44. Using ADODB TO Connect To Sybase
  45. Solved: Fill Down to cells that appear blank
  46. problem with subtruct
  47. import data to ms excel
  48. Do Static Class Methods Exist In VBA?
  49. Solved: Splash Effect Object on Userform
  50. Excel Pivots to PowerPoint
  51. Toolbars (not VBA related)
  52. Insert Page Break when values change
  53. Solved: Setting the value in another worksheet
  54. Solved: Problem with ListBox RowSource
  55. Spreadsheet functions, Add-ins and autocomplete lists
  56. Use Cell Value in Code
  57. Using Arabic on a userform
  58. Error when Closing a file
  59. Solved: Help needed with Delimiting
  60. Working with data from two sheets
  61. Testing whether filtering is active.
  62. LinkedList Implementation
  63. Solved: Data Validation Drop Down - Changing the parameters
  64. Solved: Delete from special character
  65. extract certain cell value
  66. Enum ToString's
  67. Help in saving datas without leaving spaces in between
  68. Uppdate cellformat in cell
  69. Solved: Is closing a recordset always necessary?
  70. Solved: Simple Macro
  71. Solved: How to Unhide Col 'A' ?
  72. VBA-Group rows, copy to new worksheet
  73. Solved: Self referencing cells?
  74. Unable to output variable's content to cell
  75. Solved: CountIf, or maybe something else
  76. Protect cell range with password
  77. ComboBox converting Date to Number
  78. Solved: Pivot Table refresh issue
  79. Extending/ Adjusting CSV files using VBA
  80. VBA Macros Help
  81. Autofilter contain ctriteria
  82. Pulling numbers from a character string
  83. Force user to enable macros and links on worksheet_open object
  84. Solved: Userform query
  85. Solved: Manipulating Files on Network Drives
  86. User Form - Get data from worksheet
  87. Solved: Sheets and Modules Problem Passing Values
  88. help needed for copying onto arbitrary named wksheet
  89. Solved: Pivot table trouble
  90. Solved: calling a macro based on cell value each time it changes
  91. Display alert when target date is less than current date
  92. Solved: Find record and edit field in database
  93. Solved: Help showing end date and time.
  94. Connecting to MQ Series Queue using EXCEL VBA
  95. Disabling the "Do you want to update..." message
  96. Solved: Create folders based on values in Column A
  97. Solved: Programatically Print
  98. Just one click
  99. Solved: passing cells to a function
  100. Solved: Remove Details From List
  101. Need help writing a UserForm
  102. How to detect "no source data" on pivottable
  103. Solved: Sort 97
  104. display a "Please Wait" box while calculating
  105. Solved: Copy Data from Excel sheet into Another Macro
  106. Solved: 2000 compatiblity: Pasting to merged cell using macro
  107. Control TypeName
  108. Solved: Count with differ.name Sheets
  109. Solved: reproduce single invoice
  110. Quickly delete rows with value > 80%
  111. Solved: problem with running operning script Excel 2007 due to Enable Macros...
  112. Programmatic Web Queries
  113. Copy from one workbook to another
  114. Solved: Color columns basis input values
  115. Solved: Restrict user to close the file if a cell is blank
  116. Summarizing Data from a Table
  117. Cut And Paste Selected Rows
  118. Solved: select all unprotected cells
  119. copy and paste macro
  120. Help with Creating directories & subdirectories
  121. Open a specific word doc
  122. Solved: Non-VBA help - VLookup type thing
  123. Disable Save As option
  124. Extracting data from various excel reports using VBA
  125. Solved: Data Validation - Avoid Duplicate Entries
  126. Solved: Macro in Excel to update/overwrite tabs of the same name
  127. get the Name displays in Start Menu
  128. Search for Record in Userform
  129. general question
  130. problem with subtract
  131. VBA % Calculation
  132. VBA Macros Help
  133. Excel - Colourfunction
  134. copy rows to new sheet
  135. Export only one Sheet without deleting the others?
  136. Solved: Ucase
  137. Read-Write Message Text files
  138. Genrate simple calculations and check them
  139. Solved: is it possible to return a formula into a cell?
  140. WRITING A VBA CODE
  141. sort by font color
  142. VBA Array Syntax
  143. Solved: VBE Help
  144. OPEN DATA FORM
  145. Solved: Vertical pagebreak and dragging off
  146. Message Box before opening Workbook asking for Telephone number
  147. Database Userform VBA Code Help Please
  148. Request Assistance With VLookup, Index & Match
  149. Copy Range To Array
  150. Solved: updating many functions in a sheet together
  151. help edit vba code - 2003 column limit
  152. customize right click menu on chart
  153. cmdButton for Next & Previous records
  154. Solved: Search form
  155. How to avoid print dialog box?
  156. Solved: Format error?
  157. Solved: VBA Loop Using FormulaR1C1
  158. Solved: FormulaR1C1 Not Working
  159. Solved: Looping through Workbook Worksheet objects won't work
  160. How to access a campus ldap server (anonymous-bind))
  161. Solved: Toggle line of code
  162. Need Help: reorganizing exported info
  163. Help with Vba script
  164. Need code to attach a file to outlook
  165. Cannot find #REF
  166. Force Macro Help.
  167. Forms in Frames Work-around
  168. VIEW CODE
  169. Solved: Find multiple values in range
  170. Date calc
  171. Solved: VBA Hide Rows if Cell Value is #N/A
  172. Solved: Data Validation List - Refresh
  173. Solved: Copying Columns and retaining Hyperlinks
  174. Solved: Get Full File Path
  175. extract data from a closed workbook
  176. Create comment with previous cell contents
  177. Self-Populating cells with unique iidentifiers...
  178. Solved: Userform - Populate textbox with result from popup
  179. Extrange Protection Behavior
  180. Text in Footer overlaps data in spreadsheet
  181. Solved: Use a Formula in code
  182. Protecting the worksheet disables the links in the locked cells
  183. copy and paste with if
  184. Dynamic MultiDimensional Arrays - setting and accessing the various layers
  185. Solved: Test for correct display.
  186. Solved: Count Function
  187. Solved: Copying text from 7 textboxes via cmdButton
  188. Userform - Transition effect
  189. Solved: Moving Data from one sheet to another based on a value in one cell.
  190. new document creation based on the criteria
  191. Solved: How To Copy Sheet1's CodeModule To An Another Sheet1's CodeModule?
  192. Conversion to PDF
  193. Maintaining a ADO connection
  194. UserForm - Search/Update Form
  195. About referring to cells
  196. Can't find the personal macro workbook
  197. Alternative to ActiveSheet????
  198. commandbar combobox
  199. Time Sheet Creation
  200. Building a Calendar in Excel?
  201. MS Query / Pivottable / NamedRanges question
  202. Solved: Delete blank rows.
  203. Warning message after Update links
  204. VBA Help Moving XL Cell Contents based on data type
  205. Solved: VBA Internet Explorer References
  206. Drag and Drop between ListViews
  207. Solved: macro to remove data from list
  208. Solved: Toolbar Menu Icon- Caption problem
  209. Filldown is not working as desired
  210. Userform - Shared Wookbook - Error
  211. Using SheetChange Events with validation
  212. Solved: Shell Winzip Error
  213. Excel to Word using Bookmarks
  214. Solved: Pivot Table(s) - Refresh
  215. can anyone help me convert in this formate 8' -5/8" into 100.625 inchs
  216. Charting data from a changing linked cell over time
  217. Solved: Excel 2003 converted to Excel 2007 help.
  218. Solved: Folder path
  219. Solved: auto changing cells
  220. Solved: Shell Help
  221. Solved: Code Errors out on Pivot Tables
  222. Access functions from Excel
  223. Rows to Columns
  224. Delete Hyperlink from Each cell
  225. Locking cells for editing.
  226. Timer
  227. .formula hyperlink problem
  228. Filter rows on multiple criteria within a single column
  229. Dynamic List of Unique Records
  230. How to creata a History file without sharing
  231. need vba help in excel
  232. Solved: VBA Transfering data from excel into a word document.
  233. Solved: Create Invoice from datalist
  234. delete entire rows with criteria
  235. Sum Unique items from Advanced Filter
  236. how to auto-fill
  237. Solved: Filtering Out Rule Names & Choosing Records
  238. VBA Get InternetExplorer Object
  239. Solved: Indirect not working with sme Yahoo tickers
  240. Different ways to call a sub or a function
  241. Solved: Cell Colour Format from front sheet
  242. Show date and time
  243. Copy from a single cell to a merged cell
  244. Solved: Finding .zip files in directory
  245. Providing access to certain macros to all users
  246. Filter records basis inputs in form
  247. Solved: Magazines
  248. Solved: page breaks
  249. Solved: Is DoEvents really that slow
  250. Solved: cancel parameter in macros