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

  1. Copy updated sheet from closed workbook
  2. Solved: Auto_Open/Auto_Close
  3. Insert alternative rows
  4. Run-time error method ' ' of object ' ' fail
  5. macros cannot be found
  6. Passing multiple arrays between sub
  7. Solved: Get The Replaced Cell's Address
  8. Solved: Search Formula limits exceeded
  9. Code to Undo & Re-Do
  10. Solved: How to Use VBTAB
  11. Installer for Macro
  12. Getting chm help file to open from menu
  13. Formula for counting used rows - Anomalie?
  14. Solved: Transfer Data to Another Workbook
  15. How to RAR a folder via VBA?
  16. Number format
  17. set a variable equal to the sub name
  18. save a file to a defined destination
  19. Solved: Feed Word with changing data from excel
  20. Solved: merging worksheets matched on 'key' in column
  21. Printing each sheet to pdf with a unique pdf password
  22. Spreadsheet to Form Help
  23. Solved: Windowstate = xlnormal then Center Position?
  24. Solved: Calling a Subroutine
  25. Saving data from several objects to 1 cell
  26. Solved: Indian number format
  27. Solved: Number Stored as Text
  28. If statement
  29. Word.application????
  30. Loop Help to find Intersection Cell Address
  31. Excel GUI : Activate a button from macro
  32. Findout Max value
  33. Solved: Macro help
  34. FYI - Adjust zoom, orientation, and papersize automatically
  35. Looping/Code Consolidation
  36. Delete Add-in with code
  37. do a v-lookup on a closed workbook
  38. Counting
  39. How to give a button a fill color?
  40. date in vba when paste defaults to american
  41. Solved: What is wrong with this thing??
  42. Dynamically Created Toolbar with Custom Icons are Blurry
  43. Copy Variable Range
  44. Code to add a menu, macros to it and remove when book closes
  45. Extracting Data from a PLC
  46. initialize active X control
  47. Solved: can we have Greek letters in label caption?
  48. Solved: CheckBoxes
  49. Can these functions work with arrays?
  50. Solved: Listbox populated by Userform selections
  51. Solved: Enable & Disable Macro
  52. Solved: Substitute Workbook Source Name?
  53. Solved: Add If Statment to w/ Array to Loop
  54. Add to Pivot Cache based on Criteria?
  55. If statement and Qualifying help-- please
  56. Save Excel File to Fileserver via Macro
  57. Solved: Multiplying cells
  58. Extract data from closed workbook using VBA with data range unknown at start!
  59. VBA recolor fonts to paste into other apps
  60. hide active window using Auto_open
  61. Solved: Ampersand function help
  62. Solved: Rename a macro module
  63. UsedRange, copy paste values?
  64. Solved: save as excel file automatically
  65. auto close
  66. auto email generation
  67. auto update
  68. Solved: auto population of data
  69. Solved: Charts - Using Two Y Axes
  70. Solved: Any better suggestions for checking cells before row move?
  71. Solved: Text file extract
  72. Finding Print Area per Page
  73. Solved: Count Sheets With Specific Name
  74. Need to open Outlook Template out of Excel
  75. Making a Database out of Excel
  76. Solved: Create worksheets based on column
  77. is it possible to delete a workbook with code?
  78. Solved: Find Next
  79. Using a Variable in a V-Look up formula
  80. Solved: How do you make text wrap in a textbox?
  81. Solved: Mouse/Cursor Speed
  82. Solved: Using a range in a chart with VBA
  83. excel to access
  84. Find Cut and Paste at bottom
  85. Solved: Counting 1's in a column
  86. Exporting charts as GIFs, help needed
  87. changing code with code
  88. Solved: ActiveWorkbook.Activesheet
  89. Solved: Forcing correct data entry
  90. Solved: Code is calling Private Worksheet Code, Why?
  91. Solved: Edit this loop to loop through all Sheets
  92. Solved: Auto Close WorkBook when Idle
  93. Copy Filtered list / hidden data
  94. UserForm(Excel/Project/MSForms) - Color/Font List Box
  95. Solved: Left zero to appear as blank
  96. Good online tutorials/Where do you learn vba from?
  97. Variable scope problem
  98. Link Update
  99. Solved: not able to show all data autofilter problem
  100. Replace function not working in script form.
  101. Solved: Parameter passing with Command Button
  102. Solved: Insert rows while preserving data
  103. If statement..run macro
  104. Solved: vlookup filename
  105. Solved: return missing value
  106. Solved: Add a named workbook
  107. Object disconnected from its client error
  108. How to copy Name
  109. Solved: UCase Procedure is converting formulas
  110. collection keys
  111. Solved: Two validation in one cell
  112. Discussion on Objects
  113. Adding Description to UDF
  114. Solved: Hide WorkBook then Userform Show
  115. Solved: Transform the position of data on a table
  116. reference myinput in vlookup formula
  117. Solved: Trim Function...
  118. Solved: Hash Problems
  119. Password Help PLEEEASE !
  120. Solved: Entering Cell Comments On A Protected Worksheet
  121. VBA to open spreadsheet (name dynamic through var call), extract and process data
  122. Solved: Paste Special between Worksheets
  123. Solved: Data From Previous Months file
  124. Solved: Detect if a form is opened
  125. Email using VBA and AOL
  126. Solved: Convert to proper
  127. Disable Cut in a Specific Range
  128. Check Lotus Notes if Open
  129. Solved: Add item to File Menu Bar in certain position
  130. Elseif ?
  131. Add hyperlink to unknown sheet
  132. Add toolbar on workbook open
  133. Solved: Weird Error Message
  134. SumIf using background color as criteria
  135. Solved: Add textbox values to database using loop
  136. What's the difference between VBA.method vs Strings.method
  137. Solved: Creating Drop Down Lists that Filter
  138. Solved: update from master data
  139. Solved: Accessing Target Spreadsheets existing VBA Code
  140. Find string in sheet and pass location to variable?
  141. Looping through worksheets question
  142. Solved: Multi Column Listbox
  143. Solved: Save As and replace existing file
  144. Solved: Dynamic Autofill?
  145. Solved: Creating success variable from FollowHyperlink
  146. ENABLE FILE SAVE & REMAIN IN THE SAME WORKSHEET
  147. Solved: File Address
  148. Solved: Pivot Chart Positioning
  149. Solved: Display records against Single Date
  150. Solved: User form to appear when certain cell are clicked
  151. Insert row code help
  152. Search table, copy rown and paste into new sheet
  153. Solved: How does this line Select D5
  154. Solved: Command Bar Position
  155. Solved: how to paste a value
  156. Compare 2 Columns & Return In Third
  157. Combining 2 files in one
  158. Change Directory on Workbook Open?
  159. Hide Rows based on 3 column variables
  160. How do you search a cell for key words?
  161. get cell address without the $'s
  162. Solved: Text Format
  163. Solved: Hide hyperlink address
  164. Setting Default Property in a Class Module
  165. Solved: Tricks with Zips
  166. Convert a range to Proper Case
  167. to automate cells with a hyperlink
  168. examning if a cell is emty
  169. How to add a column to a collection
  170. date
  171. Solved: Select printer & sheet code modification
  172. Solved: Can excel disable close button at right corner
  173. Solved: Trying to delete rows based on 3 variables
  174. user form
  175. Data manipulation with files
  176. Listbox control help
  177. Stock data downloading code
  178. Solved: If....Flash cell-Module
  179. Listbox column Headings
  180. Solved: Select Range with variables
  181. Solved: VBA beginner: Code in the Workbook_Open() does not get called
  182. VBA pass by reference or value
  183. Solved: Auto_Open Query
  184. Open Up a Store Email Template out of Excel
  185. Solved: add leading zero(s)
  186. Solved: Import Word Table & text into Excel
  187. Solved: Can you set Security through VBA?
  188. Access to Excel transferspreadsheet and automatic sort data
  189. Solved: Any way to prevent repeating the same executing code for 4 worksheets?
  190. Solved: application.speech.speak
  191. Excel 2007 - Application.ScreenUpdating won't change?
  192. file search/auto import in excel 2000
  193. Solved: Copy PDF into Excel and Keep PDF Structure
  194. Solved: Find empty cell
  195. Solved: Delete empty rows
  196. Solved: function to retrieve characters between to given values
  197. Solved: Make cells inactive
  198. concatenating strings & data from ranges without typing a formula
  199. Solved: how to diferentiate between text and value?
  200. Items in Dropdown box of Internet Form
  201. Solved: Force user to fill cell
  202. ADODB.Connection Copy RecordSet to Array
  203. Formula help
  204. Solved: Data Validation / Array
  205. Solved: Copying and Pasting from each Spreadsheet in a Folder
  206. Mask the Salary
  207. Solved: graying out check boxes
  208. Error - manipulate dates in VBA
  209. Solved: How to Determine Which Fonts Are Being Used (Loaded)
  210. Solved: How to Clear the ?Last Cell?
  211. Selection not displaying in dropdown box
  212. Solved: User Defined Function
  213. Sort
  214. Solved: Need help with this macro
  215. workbooks.open question
  216. Sheet and cell validation
  217. Solved: Insert code to worksheet programmatically and run it in the same Sub - compiler error
  218. Solved: Find Method not working properly
  219. how to connect one excel file to another?
  220. Solved: File Exists Issue
  221. Solved: VBA tutorial greenhorn
  222. save file as CSV
  223. Multiple Worksheet Entry
  224. Solved: Populate Specific Column Cell based on ListBox Selection
  225. Solved: extracting info from cells
  226. Ignore blank in Data Validation
  227. Solved: Combobox column width
  228. Solved: Add text in title bar
  229. Solved: Choose sheet code
  230. Solved: Looping required
  231. Auto deletion of data when deleted from master file
  232. Create/Clean-up of Objects
  233. Generate Exe from Workbook
  234. Additional Control in Vista
  235. Uninstall ADD-INS
  236. Solved: Array as a Public Const
  237. Convert Formula R1C1 to Range
  238. Solved: Question on Option Buttons on Forms vs Control
  239. How to make a range dynamic?
  240. Solved: ?Cells? and ?Range? Properties
  241. Delete Rows Based on Partial Cell Value
  242. Save as the active sheet into a new workbook
  243. Solved: LastRow on every page
  244. Importing CSV Files Without Preserving External Links
  245. Solved: how to find charecters in texts?
  246. I'm new to this and trying to fix an error
  247. Combine rows from multiple different worksheets / workbooks into a Master workbook
  248. Creating a List in Memory
  249. Solved: Hidding Data Hides Chart, Why?
  250. Add " at the beginning and end of a string