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