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