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. password protection
  2. transferring problem
  3. Screen shudder and jumping during macro run
  4. Solved: Copy cell to multiple rows
  5. Array or multiple lookups help
  6. Solved: TextBox BackColor when Enable
  7. listbox.value blank while listbox.list(listindex) accurate
  8. Solved: Date Search - error handling
  9. Solved: Count Based on two Criteria
  10. Application.StatusBar errors
  11. Solved: Chart - Gridlines
  12. Inputbox to force users enter date as DD/MM/YYYY ONLY
  13. How to force users to enter Four Numbers ONLY in inputbox
  14. FIFO REPORT
  15. Check cell for Valid Date
  16. Excel 2007 . . . Arrrgh
  17. "Object not found"
  18. Solved: Align Text
  19. [SLEEPER:] Problem calling function twice
  20. [SOLVED:] Chart Object set Marker type and color
  21. Can't add book as an attachment
  22. Need Direction/Guidance
  23. [SLEEPER:] Application.FileSearch doesn't work
  24. Automatic Entry
  25. iteration loop
  26. EXCEL DELETE
  27. Solved: Copy files from folder to folder according to list
  28. [SOLVED:] determining user input
  29. Index Macro
  30. Activecell.movenext?
  31. Looping through controls having specific properties only!
  32. Workbook "Save As" Method - Question
  33. What's the Name of that?
  34. excel_copy
  35. Alternative solutions for adding the first cell of the columns of a worksheet to a li
  36. How to access the items in a row or column(i.e a cell) in Excel as Objects( Items ) ?
  37. [SOLVED:] Is the Child different from the Family?
  38. All our names are given to our heads only!
  39. One Kinter-Garden Question
  40. I know they all are criminals(a specific datatype) But dont know how many?
  41. Ranking Based on criteria
  42. Solved: Selecting First Empty Cell in Column A
  43. get value from not opened excel file sheet.
  44. excel
  45. Post Excel UserForm data based on Selected ListBox value
  46. Solved: Cell Address Value
  47. VBA Help: Inserting new rows with data
  48. Recorded excel macro doesnt work :( I need a help ASAP
  49. Display results of CTRL+F in the middles of the screen
  50. [SLEEPER:] Excel data to Word Mail Merge via VBA
  51. Solved: Copy Cell and Comment
  52. auto update with cell value change
  53. Excel 2007 and ATPVBAEN.xla (Phffft!)
  54. solver add in
  55. Need help for searching duplicate rows in a worksheet
  56. Message Box for Column
  57. Date calculation error
  58. Shared Workbook?!! PLEASE HELP
  59. Solved: Prevent Row Insert - (Above Row 1)
  60. Solved: Highlight vba code
  61. how to read Excel file
  62. Solved: set ListBox row source automatically for each sheet
  63. Delete automatically opened workbook
  64. Solved: IF statement
  65. Solved: How to delete active row and up to a defined row number
  66. Insert Blank row between rows with values
  67. [SOLVED:] VBA to select picture in a comment
  68. Solved: Get Subrange from a Range
  69. Help with finding the right function
  70. Cell Validation List from a UDF
  71. Solved: Excel Userform Datagrid
  72. count days
  73. Solved: Check if aRange = anotherRange
  74. Vba for Export Pic
  75. Solved: How to add continuous value under one set of column
  76. Highlights Duplicate Entries
  77. Solved: search across multiple worksheets
  78. Solved: Delete specific rows too slow
  79. Excel 2007 file search
  80. Who Opens my WorkBook
  81. downlist and formula
  82. Solved: Nested Range Names
  83. macro activate button to run another macro ?
  84. Solved: Conditional Formating - Formula Help
  85. Changing data refered to by varying named ranges though a macro
  86. Solved: Excel problem
  87. Solved: Excel ADODB Connection resulting in 'Catastrophic Error - 2147418113'
  88. Insert new Row
  89. Populate a Sheet with Active Directory Computers
  90. [SLEEPER:] gmail
  91. [SOLVED:] Application.Quit doesn't quit?
  92. Solved: check in wb if is filled all what is needed
  93. Solved: Need help error trapping / event / alert trapping??
  94. Solved: Disable right click on images
  95. Solved: Delete Rows if cells in columns are empty
  96. Excel 2007 Macro Ref Libraries
  97. IP address manipulation and lookup in a spreadsheet
  98. excel add-in in 2003
  99. Solved: Apply Formula in Column B if Column A has Data
  100. Recordset recordcount property
  101. Solved: recurring date - wildcard ?
  102. Data format changes after sending email
  103. Solved: Put picture in top right corner of cell
  104. Solved: Unlocking an embedded object
  105. Excel 2007/2003 files access
  106. Solved: Data Validation help
  107. Solved: TRIM STRING
  108. Not able to click a button on a webpage
  109. VBA which finds data in one sheet & return list with all relevant data in new sheet
  110. Solved: update opened read-only wb
  111. MISSING: Ref Edit Control
  112. VBA to Find and compare data from multiple columns
  113. Setting Sheet Visible Error
  114. msgbox more than 1024 chars
  115. vb script to copy selection
  116. Combobox items
  117. SOLVEROK
  118. Select and name a Range
  119. Counting date cells
  120. Run macro IF
  121. Solved: Pick up peak(maximum) value in running data
  122. Fetching data from the web
  123. Get information from a .MDB file
  124. Simultaneous Entry
  125. Solved: letter index
  126. [SOLVED:] How to use DataBodyRange property to write to a specific sheet?
  127. Solved: Need to include Scientific Labels to a Form
  128. Solved: delete leter
  129. search for word
  130. VBA: Copy chart from excel to word
  131. Shortwrite
  132. Write a string of text to all HTM files
  133. Save Progress Bar Not Displayed
  134. Changing worksheet issues
  135. ATPVBAEN.XLA . . . One More Time
  136. Solved: Searching in multiple workbooks
  137. counting
  138. Solved: VLOOKUP question
  139. Solved: Floating a textbox over an excel worksheet
  140. Solved: auto number
  141. Solved: product begins with XY
  142. [SOLVED:] Help with formula please
  143. multipage search - duplicate entries
  144. Stop running macro after specific time
  145. ListBox Help!
  146. 16 Digit number output
  147. Assist with Hyperlink in Email
  148. Run a Macro when you click on a cell
  149. Solved: Copy and paste as an object
  150. [SOLVED:] Formatting New to Excel
  151. [SLEEPER:] Create Access database on the fly & import csv/txt file as table!
  152. Solved: Count Files in Folder
  153. get rid of unwanted characters and send to new txt or xls file.
  154. [SLEEPER:] Multiple Macros for one Workbook/sheet
  155. Push Excel Named Range to Word Bookmark
  156. Bug with shortcut for macro??
  157. Error while running Macro in excell
  158. Porting UserForm to network of users
  159. Solved: How to know when Webquery has finished updating
  160. Solved: Dynamic Drop down based on a dynamic named range
  161. Solved: Need macro for this pivot functionality?
  162. Solved: VBA AUTO FILTER
  163. round + sumproduct help
  164. Maximum limits
  165. Solved: VBA colours appearing as grey for other users
  166. Find Desktop Folder Files
  167. Copy to new workbook the active sheets and erase the content of the original
  168. Function Argument Window - Can it be expanded?
  169. Application-defined or object-defined error
  170. Solved: Find and replace values from separate spreadsheet
  171. Solved: Copy sheet without the vba code
  172. macro to add addtional pivot tables after the first pivot table
  173. [SLEEPER:] 2010 excel calendar
  174. Protect a worksheet at startup with VBA
  175. [SLEEPER:] Date on Userform
  176. Solved: Create Custom Menu Macro Items in Excel VBA
  177. move pdf files
  178. Solved: Controls.Remove causes unexpected behavior
  179. [SLEEPER:] Macro to Search and Replace word within another Macro
  180. [SOLVED:] VBA Target.value
  181. Solved: Msgbox if value not found
  182. HELP WITH CONCATENATE DATA
  183. Listbox query
  184. why it find only each second value
  185. Query a sheet using SQL
  186. Extended Conditional Formatting
  187. Find duplicate cells in a column and contitionally delete the dupes
  188. Error in the creation of multiple PivotCharts
  189. Create New Macro Using VBA
  190. Solved: TIMER SCALE IN EXCEL
  191. Find "Hard Coded" cells?
  192. Custom Messaging with Mouseover
  193. Prevent / Disable Sort function ?
  194. Solved: Update an excel sheet, by loading from an object
  195. Solved: Count the same items in a column
  196. Solved: conditional formatting
  197. Solved: Code works as Sub but not as a Function!
  198. Dimension x number of arrays based on user input
  199. Weird Add-in Error
  200. macro to conditonal format and negative numbers
  201. Need Help With a User Form
  202. Solved: Query within Excel to SQL server with VBA Code
  203. Graduated Cell Colour in Excel 2003
  204. [SOLVED:] Multiple fonts in excel forms textbox
  205. Not delete or move an excel file
  206. utomatically close the shared spreadsheet
  207. Charting Question with Line and Scatter
  208. Regular expression to find negative number
  209. Solved: Retrieving comments from a worksheet
  210. Excel, Date find issue
  211. Search / Find - across sheets - find multiple instances
  212. Solved: macro help
  213. [SOLVED:] Vba Replace Function
  214. Solved: Stopping a file from being opened
  215. Looping through cells and move sheets from file in folder.
  216. Excel VBA beginners exercise
  217. manipulate two sheets
  218. Select Previously Edited Cell
  219. Solved: select
  220. Path finder
  221. VBA findAll Copy & Paste
  222. sum by cell color
  223. parent window refresh
  224. Userform submit to Worsheet (Subscript out of range)
  225. Solved: Removing items from menu bar
  226. SQL using Excel VBA & passed to Access doesn't run, runs directly in Access!
  227. Auto width of a listbox on a userform?
  228. Need EASY help with a plot
  229. autonumber depends upon start date
  230. Determining the working days
  231. Solved: TIMER
  232. NUMBERS HELP
  233. Solved: ComboBox - SetFocus ?
  234. Date Modified
  235. Open .csv from code
  236. [SOLVED:] call stack question?
  237. Automated formatting
  238. Solved: Delete Rows That Total 0
  239. Array navigation
  240. Not able to save add-in file under different name
  241. Compare two doubles
  242. Update report filter across multiple pivot tables
  243. Solved: Now Function - convert to General format ?
  244. Solved: windows scheduler and application ontime
  245. Solved: some countif ...sum if help
  246. Solved: Send email from excel
  247. Solved: Hide custom CommandBar form Popup Menu
  248. Autonumber form but be able to save as file each time
  249. Simple simulation help
  250. name box extender