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. Opening files simultaneously
  2. Autofill Macro from EXCEL to WORD
  3. Renaming the files in all the folders
  4. I need a macro file that could recognize the same rows With similar data and remove t
  5. data from all the html files in an excel
  6. Prefix with "-" sign
  7. Solved: Fully clearing the used range of a worksheet
  8. code error going from xls 2000 to 2007
  9. Solved: Formula For based on blanks
  10. Solved: Count highlighted rows
  11. Change Tracking - possible without custom views?
  12. Need to reference multiple workbooks
  13. Get Key
  14. save as
  15. Solved: combobox populate
  16. VBA codes for skipping cells
  17. Solved: Compile Error of Duplicate Decleration in Current Scope
  18. find duplicates with different data and extract it
  19. Create New Workbook from existing Tab
  20. Solved: Find value, input into a different column
  21. VBA-PERL via .bat
  22. Solved: Importing a .txt file without a user prompt
  23. Multiple Page Print Form
  24. Lots of small queries in a small database - performance problems
  25. Remove string before a certain character
  26. HTML save not working
  27. Help with VBA Excel project please!
  28. Solved: Remember Hidden State
  29. Change font for part of a cell
  30. Combining Multiple Workbooks / Worksheets
  31. Button Image
  32. Solved: save problem
  33. Controlling the number formats in a file
  34. VBA Forms Module Help please.
  35. EnableOutlining problem - It is driving me mad!!
  36. Solved: show very hidden
  37. application not visible flashes
  38. Help with small project for work please
  39. Looking for VBA algorithm for circular references
  40. VBA Excel macros
  41. Create PDF Stopped Working.... Help!
  42. User Form /COMBO BOX 1
  43. Solved: Workbook_Open loop??
  44. Solved: VBA Reference Protected Workbook
  45. Solved: go to vb studio?
  46. Solved: textbox line under the text
  47. Solved: Auto Unique List
  48. Userform to edit records in different sheets
  49. I would like code to show active workbook
  50. Solved: Specifying file location in a cell and referencing to that cell in VBA, ASCII of 0 to
  51. Solved: help with the first program
  52. Avoiding Variants
  53. Excel exported reports have problem
  54. Adding a column to highlight the changes while comparing two version of excel sheet
  55. Solved: Sum if or sumproduct help?!
  56. Solved: values in range
  57. Copying Autofiltered data, pasting all data when autofilter shows no data
  58. Solved: Create dynamic range to use in formula
  59. Hide rows with bold text
  60. Perform action only if mutiple criteria is met
  61. Solved: call windows printers
  62. Sending Email in Excel
  63. VLOOKUP in VBA
  64. Combining mutiple excel files
  65. Copying certain cell on condition
  66. Searching many sheets for data
  67. Using name manager
  68. Solved: displaying certain line of text from notepad
  69. displaying certain line of text from notepad
  70. Trouble with Grouping
  71. Solved: ListBox1.RowSource for visible Rows.
  72. copy cells from one sheet to another
  73. moving folders based on a criteria
  74. Text To Columns VBA
  75. Solved: Form run time
  76. Creating Text Files from excel each row
  77. HOW TO OPEN EXCEL ADD-INS IN TO VIEW CODES
  78. VBA Coding: Font Change
  79. export worksheet to a txt file
  80. Copy rows to new tabs based on value in 1st column
  81. Solved: Cut and Paste cell value between 2columns based on criteria
  82. VBA code for comparing a worksheet with a column and show the result with a color
  83. QR Codes for Excel 2003 XP
  84. insert range of cells if data in column doesn't match
  85. Copy and Paste Problem
  86. Workbook_BeforeSave
  87. Solved: VBA to auto email report
  88. run macro automatically based on criteria in other spreadsheet
  89. Fixed/non volatile date function
  90. Copy between sheets
  91. Solved: average offset rows in a column
  92. Macro to update Sheet2 based on Sheet1
  93. Indentify column references for cells that meet criteria and assign them to variable
  94. Solver VBA reference in non-english Excel
  95. Solved: textbox focus
  96. combobox one last push
  97. create log for entire file
  98. Solved: I have exceeded Excel’s limit of 1048576 rows while importing data from a file
  99. Timeformat Sum Up and Separation Based on Conditions
  100. Cell reference copy in another cell without link and formula
  101. Object required error with VBA rows deleting
  102. Formula solution for repeated search in column
  103. Solved: Copy selected range in autofilter
  104. Insert the name of the worksheet in cell and than link the cell to another worksheet
  105. Count If
  106. Update powerpoint from excel macro
  107. Excel VBA Macro Crashing
  108. Solved: if & vlookup formula : help requried
  109. Disable alert message
  110. pulling data from multiple worksheets
  111. Select Case Function
  112. problem inserting formula with R1C1
  113. Run Time Error 7
  114. UserForm_Terminate
  115. Sub / Function recorder
  116. New project
  117. Spreadsheet data management
  118. Solved: Find and Replace for Time
  119. Do Loop with InputBox and ActiveCell Ref HELP!!
  120. Solved: AutoFill TextBox in UserForm
  121. Highlighting Cell in Variant
  122. Solved: web navigation
  123. looking for an Event that fires when an existing Workbook is opened
  124. Opening Excel file and running macro
  125. How to save filename with -v2 -v3 and so on at the end if file name already exists
  126. Solved: Turning multiple quantities into singles
  127. Referring to excel application
  128. Solved: Trouble looping through ranges with non-adjacent cells
  129. Automating calculations between values on 2 separate worksheets
  130. VBA knowing which cells it has filled?
  131. Combine "if" formula : help required
  132. Bulk Copy / Pasting
  133. Automatically fill cell when data entered in another sheet
  134. Macro crashing excel
  135. Please help me find out the data link of the website
  136. Subtracting Values of Range Variants
  137. Status Bar or Progress Bar
  138. Solved: Concatenation of many cells from another workbook as a “block text”?
  139. Filtering the values and removing the duplicates
  140. Solved: OLECMDID_SAVE or SAVEAS pvain pvaout
  141. Parsing an RFP Word Documnet to Excel
  142. help with code please for arrays
  143. Reset MOST of Worksheet with Macro
  144. Graph in VBA
  145. auto save workbook upon close
  146. Solved: filter bloks
  147. Solved: ChangePivotCache - PivotCaches.Create Problems
  148. How to Loop through columns in an Array and write to a range
  149. Add additional data to word document's bookmark in excel
  150. Solved: Subtotal() generates extra lines
  151. File Copying From/to different Folders
  152. Solved: Downloading File issues - Buffer Length invalid or not enough memory
  153. Text to Excel VBA
  154. How to show save as dailog box
  155. Solved: macro to read a cell and subtract a number?
  156. How can I display a list of folders and files in window?
  157. error when puting more than 1 string
  158. Help on Extract portion of string in the right way
  159. need to help: mid function
  160. Move data from Excel 2007 to Access 2007 using VBA
  161. Copying last value of a column
  162. Impoting excel sheet to new workbook
  163. date help
  164. Solved: If values in row cut/paste
  165. If the selected cell does not have a comment, then insert a comment.
  166. Ways of declaring arrays
  167. Changing Multiple For Each Statements Together with Next - VBA
  168. Solved: leave the ActiveX text box, pressing 'Enter'
  169. Data Feed to Excel using XML from a website
  170. Formating prob
  171. Select dates by current month
  172. first post....
  173. Unable to get the Vlookup property of the WorksheetFunction class
  174. VBA Nested Lookup as a UDF
  175. Solved: VBA count files funtion
  176. Solved: How to repeat a procedure/code a number of times
  177. Solved: Return which control triggered an AfterUpdate event
  178. Autonumbering invoice then saved to another worksheet in the same workbook
  179. HTML Source Code from Safari/Mozilla on mac
  180. Build a tree of called functions / procedures
  181. Adjusting array of values for filtering for actual values in sheet
  182. Saving file
  183. VBA for Updating Pivot Table report filters from a OLAP Cube
  184. Form Display stops at FormName.Show - Why
  185. Solved: Whenever cell is added will be recorded on another sheet with date and time and value
  186. Copy a cell from excel to word and aligning center using VBA
  187. how to make add-in load before workbook
  188. HTML Source from IE
  189. Solved: Delete Rows with Condition
  190. excel 2007 cell context menu question
  191. Solved: Array Not Working
  192. Solved: Get Textbox Value
  193. Help with macro to update text on shapes
  194. Solved: Select the cell with the click of a mouse, and have the result of calculation
  195. Solved: How to get Last Key or Key-Combo Pressed (Not Event)
  196. Solved: Moving files from different source folder to different destination folders
  197. Solved: Parsing Addresses
  198. Help with Macro and Object Variable
  199. Pull info from one Active Workbook and Save in Another
  200. Solved: If wb is open give message
  201. exe
  202. UK National Insurance Number Validation
  203. data conversion
  204. Solved: VBA to create a separate sheet for each month
  205. Right click option menu...specific items
  206. Invoice Processing
  207. Input difference words run difference macro in one textbox
  208. Open XML file in Notepad and delete all "-"es
  209. Solved: Hiding columns
  210. VBA Code to export Excel to OVERWRITE an EXISTING PowerPoint
  211. display worksheet data in user form
  212. Convert sub to function - prompt not appearing in formula bar
  213. Solved: Print pages that contain data
  214. Solved: Increment Formula With If Statement
  215. Boost Macro running speed
  216. group data
  217. Solved: Removing Duplicates for Multiple Columns independently
  218. Solved: Report to collect filtered data from multiple sheets and consolidate
  219. Hide columns based on cell value
  220. Copy from one worksheet and save to another
  221. Solved: Lastrow +
  222. Validating more than one textbox for Null values
  223. Solved: Sum particular data
  224. Solved: Simple VB? Take one file and make many
  225. HTTPS GET REQUEST ***HELP***
  226. Passing variables
  227. VBA code to send excel sheet as PDF
  228. Combining MsgBoxes into one box
  229. Userform limit?
  230. Solved: how to make shipping label with picture
  231. Find 1st Empty Cell in Range
  232. Formating (pivot)
  233. Want to create a variable that references a cell
  234. How to copy and paste the date
  235. Force ontime Macros to run one after another instead of simultaneously
  236. Solved: Move to Next Record
  237. Solved: Moving cell values based on specific criteria
  238. VBA code for Cursor to stay Stationary in one cell
  239. Automatic Calculation when sheet tab clicked
  240. SaveCopyAs not working.
  241. Urgent VBA Debugging help
  242. Concatenate string with itself in a "while" loop
  243. MultiPage in UserForm
  244. How can I change part of my title by referencing a value in a cell?
  245. Create Desktop Shortcut - Change Icon
  246. Flag on birthday calendar
  247. Solved: Macro request: Copy rows that match values in a column of names
  248. excel 2010 windows 7 64 bit hangs fooooorever
  249. Saving a file vy referencing a cell and using RDB Create
  250. Solved: Round down to nearest 5,000