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