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

  1. Copy data in a Filter table then email it
  2. Copy from Listbox to empty sheet
  3. Solved: Conditional formatting, if cell1-cell2>0.2
  4. Using arrays to scale up binary formulas
  5. Solved: My seemingly simply code is VERY slow
  6. page setup setting
  7. help with Excel Application.Filesearch replacement
  8. Run-time error '2147024809'
  9. Email most recent file in a folder
  10. Copy cell from named sheet and paste
  11. Solved: strange behavior from special cells
  12. Solved:Macro to delete selected by my rows, columns, cells
  13. Referencing Worksheets through a list
  14. Solved: OnTime events with Userforms
  15. Paste content control text from word doc into excel cells
  16. [SLEEPER:] Hiding Named Sheet
  17. Solved: userform to only accept mobile number
  18. Question on Numbered Month
  19. Solved: Referencing a cell plus its formatting
  20. For each class("addressbox") in html document follow link
  21. Format Functions Excel Add-in
  22. Repetition de de copier/coller avec saut de ligne
  23. write changes in log
  24. Solved: Transfer variable to form
  25. Time Adherence Sheet for Excel
  26. Solved: Left Function on Object
  27. Solved: criterion for cell with formula, and the date on another cell
  28. Solved: 2 dimensional arrays
  29. Vba Code Automatically Sort Rows Large To Small
  30. Code does not pull data correctly at login
  31. Macro Security
  32. Solved: Hyperlink pivot pagefield control - not working
  33. Code won't run on previous Excel version
  34. Solved: Code which formats cells
  35. Solved: VBA VLookup Number return Text
  36. Macro to populate Data from Columns into Rows.
  37. Solved: How to Hide Pivot rows with empty DataBodyRangevalues
  38. Solved: Excel Application.Filesearch
  39. Solved: Copy Selection Paste btw 2 sheets
  40. [SOLVED:] Copy Formulas Down Just One Row
  41. VBA to access website with passwords
  42. time keeps showing as 1:00 Am when it is 1:00 PM
  43. Solved: string with asterisk
  44. Editing a Macro in one file using VBA in another file
  45. Weighted/Conditional LINEST in VBA
  46. Solved: Test Last Row Value before update
  47. Row Fomula entry
  48. Macro to delete rows if criteria is referenced in other sheets?
  49. Cannot test us userform unloaded / terminated
  50. 'UserForm Calander Control
  51. Easy Copy paste - Reconciliation macro
  52. Solved: Help with IE loop Automation
  53. Solved: module Excel VBA for manage parking places
  54. Dynamic Chart won't Update
  55. Solved: Worksheet Change...
  56. I need help edit code vba automatically copy of cell
  57. VB help
  58. VB error while running the project
  59. Can One Class Hold Many Objects
  60. generic matrix multiplier
  61. VBA Code Indent
  62. VBA - Activeworkbook.save & Workbook_BeforeSave problems
  63. Give only named users acces
  64. Solved: VLOOKUP Syntax in VBA Using WB w-Dynamic Name
  65. Run-Time Error '5': Invalid procedure call or argument
  66. Password Protected userform
  67. if statement
  68. Excel to Word Insert Table Help!!
  69. Conditionally format Pivot Table cell color base on value (text)
  70. Prevent deleting worksheet
  71. determine the unit for left margin (Excel 2003)
  72. Visual Basic Out of Memory
  73. Popup Message when Specific Text Selected in a Range
  74. VBA code for Alert Message and highlight duplicate
  75. Solved: Open Password Protected Workbooks in VBA
  76. Loop cycle not copying and pasting correct cells
  77. Solved: Delete entire row if cell contains string data on Cloumn A
  78. Solved: generate a Code from Column A and B
  79. Help formatting text to columns using VBA
  80. Solved: VBA to find a value and copy values from sheet2
  81. Connecting to database from macro
  82. Solved: Need help with setting a range to some text.
  83. Solved: Combinging AND and OR in Nested If Statements
  84. Solved: int() does this weird thing. Can someone explain this to me?
  85. Save the modification
  86. May be MID and Find function
  87. Solved: How to test formulas results?
  88. RECONCILING DATA USING VB SCRIPT
  89. Macro creation
  90. Textbox expand horizontally
  91. Formatting a cell based on 2 cells.
  92. Solved: Copy Values from Information Tab to Main Tab
  93. Searching folders & subfolders from root for specific file & copy that file
  94. insert 3 blank row if find a string data on column A
  95. Solved: How to edit field values in ADO recordset ?
  96. Opening a New Instance Of Excel
  97. Auto Update (without clicking on scrollbar (on worksheet) every second!
  98. Sleeper: Code is not copying correct cells
  99. help save worksheet to new wb
  100. Tick Mark
  101. VBA to append 0000 to string dependent upon state
  102. Combine print with dynamic print areas
  103. [SOLVED:] save certain sheets as a pdf from a closed wb
  104. Multiselect listbox values to a textbox
  105. VBA code to delete certain rows.
  106. Solved: Counting by Vehicle number
  107. 1 Userform and 60 ComboBoxes
  108. Today's date and following 6 working days
  109. Solved: multiple font colors
  110. VBA to record the field settings of a pivot
  111. Creating Pop-Up Calendar: How to do in Excel 2010?Hi, I've been researching into add
  112. Delete the dash from first and end of cell
  113. VBA code to search XPS document
  114. VBA or Possible with Excel Functions ?
  115. Copy Range Based on Condition
  116. ExecuteExcel4Macro(String)
  117. obtain current SSID's
  118. Solved: Non-Continuous Range with Pivot Table
  119. print userform
  120. [SOLVED:] Simple Printer Control
  121. [SOLVED:] SQL query format
  122. Problem with the VBA code to copy cell and paste in new workbook
  123. Populate Excel Template from another worksheet
  124. Solved: Selection reference
  125. Solved: Name #? error
  126. Solved: Delete Column that do not have headers "XYZ"
  127. Solved: Another countdown query
  128. Prevent Copy & Paste From Overwriting Data Validation
  129. [SOLVED:] Just Keep 1 Row for each Account
  130. Delete ** in end of each cell of right
  131. For loop help
  132. Solved: VBA "Lookup"
  133. Calculate between two spreadsheets
  134. Send outlook
  135. To Compare two cells in row and insert column
  136. Solved: Help with comparison please
  137. Solved: Convert file
  138. vba for replacing the charater in cell
  139. Solved: Pivot Table Is Not Consolidating
  140. VBA query to SQLServer 2012 times out - Solved
  141. VBA web query java Timer with limited time
  142. Recursive Procedure/Function Caller Tree
  143. With Selection.Format.TextFrame2. Run Error
  144. calculate only when macro has been enable.
  145. Solved: Time as string with decimals?
  146. Reference #N/A
  147. Subtract adjacent values based on a condition
  148. Create a Table Using Listobject without Generating Autofilters
  149. Improper Drill-down format
  150. Sum get error
  151. [SOLVED:] Range Concatenation Help Needed
  152. Sleeper: Screen scraping
  153. Solved: Formatting help
  154. Solved: Copy From One Sheet to Another
  155. Better solution for stock charts
  156. Solved: How to let Excel "monitor" for opening or closing a random file?
  157. [SOLVED:] Creating Index Items with Dynamic Hyperlinks to Cells in Workbook
  158. Solved: VBA to update source data for excel charts
  159. Trying to save on computers with different FileFormats
  160. Copy col help
  161. Evoid Registering with duplications
  162. If row 55 is not on page 1, then keep reducing the bottom margin by 0.1
  163. code_montecarlo
  164. Solved: excel 2013 conflicting with 2010 vba
  165. Solved: Writing in any cell in the range and check the remaining sheets replay
  166. Change tab colour when condition is met
  167. Insert CheckBox to a SubItem of ListView Control
  168. How to get around userform inability to "remember"
  169. Update Progress Bar at EXACTLY 1 second Interval
  170. Solved: Add an Auto increment number in blank cell in column A
  171. VBA programming assistance
  172. [SOLVED:] Update Cell Value Based on Match to Outside Workbook
  173. Empty Fields
  174. Solved: Clearing Value in ComboBox
  175. SQL Select *
  176. help find target !!
  177. Solved: worksheetfunction.vlookup
  178. Solved: Output of DOS command to excel using VBA
  179. Solved: Split 2 Column to 2 columns with 85 record
  180. fitler by keyword
  181. Work on table while filtering
  182. [SOLVED:] VBA Copy data based on name & paste into workbook w/ named tab
  183. Copying values from a dynamic range
  184. Calling DLL function from Excel VBA doesn't return value
  185. Help with VB code please?
  186. Solved: Find row above and below searchvalue, VBA
  187. Solved: Convert time
  188. Data Validation List Macro
  189. Finding a specific text string within a cell
  190. Help with SendKeys
  191. Copy,Paste,Transpose in VBA loop -Thank you so much!
  192. lock autofilter range or autofilter part of range
  193. Having a problem debugging using SendKeys
  194. Encrypt a worksheet in a workbook using VBA
  195. delete the duplication value between 2 WS
  196. Solved: PIVOT FILTER
  197. Coding not works sometime
  198. How to access a Checkbox in a ListView per row?
  199. [SOLVED:] CLearcontent or delete rows: Keep proper count of used row
  200. [SOLVED:] How to format differently 2 parts of same string?
  201. [SOLVED:] excel automate copying cells from row
  202. Populate Listbox in "alpabetic order"
  203. Small VBA program - fast
  204. Date format problem
  205. [SOLVED:] Autosum error
  206. [SOLVED:] Subtotals
  207. Solved: Unlock Row If cell Equals Specific Value
  208. Help with Loop
  209. Character symbols for file types
  210. multiple condition if statement
  211. [SOLVED:] Reference to same word in excel
  212. VLook Up with Multiple criteria
  213. How to Link 2Combo Box select Date and Cell name
  214. [SOLVED:] VBA Code or Forumula
  215. I need help secure a workbook with a password
  216. Creating an Object Model
  217. Solved: Read Sheet name from a Cell
  218. As Integer datatype allows fractions
  219. Sumif to VBA
  220. Solved: VBA to go the sheets specified and run the macro.
  221. Project Analyzer - Procedure call tree
  222. [SOLVED:] Could this be a buffering problem?
  223. Solved: 5 small subs into 1 sub. HELP!
  224. Unable to set visible property of the pivotitem class
  225. How to test Querytable connection before actually executing SQL query
  226. Excel add multiple radio buttons
  227. Capturing Data from a user form
  228. Basic: Copy-Paste Data using xlDown multiple times
  229. Date format,crosstab in SQL statement
  230. [SOLVED:] Row Number of Cell
  231. Excel 2010 Slicer selection range
  232. Solved: VBA logical test
  233. VBA not doing Mathmitical calculation when its ran
  234. Solved: Allowing time for the SQL query to fully run
  235. [SLEEPER:] VBA to ungroup only selected values
  236. VBA to collect internet search term hyperlinks
  237. Solved: Extend selection to next three cells
  238. Solved: Conditional Formatting: Copy Formats
  239. Building a formula using VBA
  240. working with ranges in custom function
  241. Stopwatch In Excel
  242. Solved: extract row from multi row range
  243. Message box pop up for command button
  244. Complex-ish macro including averageing and choosing-data-by-identifier
  245. Does not work if there is only 1 entry in column, works for more than one enteries
  246. Solved: How update tow Chart after import by VBA finish
  247. Solved: AddIn - Unhelpful Error Message - please illuminate!
  248. Loop Issues
  249. Break Text at First Space Before Char 75, Insert Line and Move Char 75+ to New Line
  250. Solved: Pivot Chart Help