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